Entity LastSubmission

Description of Entity LastSubmission

This is to generate the IRAS direct e-submission file.


List of all Dependencies of the Entity LastSubmission

Name

Code

Class Name

Relation_1610006

Relation_1610006

Reference


List of Attributes of the Entity LastSubmission

Name

Code

LastSubmissionSysId

LastSubmissionSysId

LastSubmissionDateTime

LastSubmissionDateTime

SubmissionType

SubmissionType

IsOriginal

IsOriginal

SubmitUserId

SubmitUserId


Entity Attribute LastSubmissionSysId of the Entity LastSubmission

Card of Attribute LastSubmissionSysId of the Entity LastSubmission

Name

LastSubmissionSysId

Code

LastSubmissionSysId

Data Type

integer

Mandatory

Yes


Description of Attribute LastSubmissionSysId of the Entity LastSubmission

A system generated identity. It is blind to the user. This is the primary key for the LastSubmission table.


Entity Attribute LastSubmissionDateTime of the Entity LastSubmission

Card of Attribute LastSubmissionDateTime of the Entity LastSubmission

Name

LastSubmissionDateTime

Code

LastSubmissionDateTime

Data Type

timestamp

Mandatory

Yes


Description of Attribute LastSubmissionDateTime of the Entity LastSubmission

Shows the date and time for the last submission.


Entity Attribute SubmissionType of the Entity LastSubmission

Card of Attribute SubmissionType of the Entity LastSubmission

Name

SubmissionType

Code

SubmissionType

Data Type

char(20)

Mandatory

Yes


Description of Attribute SubmissionType of the Entity LastSubmission

Shows the type of submission.


Entity Attribute IsOriginal of the Entity LastSubmission

Card of Attribute IsOriginal of the Entity LastSubmission

Name

IsOriginal

Code

IsOriginal

Data Type

smallint

Mandatory

Yes


Description of Attribute IsOriginal of the Entity LastSubmission

Indicates if the submission is original or not, in a form of a checkbox.


Entity Attribute SubmitUserId of the Entity LastSubmission

Card of Attribute SubmitUserId of the Entity LastSubmission

Name

SubmitUserId

Code

SubmitUserId

Data Type

char(20)

Mandatory

Yes


Description of Attribute SubmitUserId of the Entity LastSubmission

Shows the identity of the user who made a submission.