Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Assignment Id |
The automatically generated primary key of the asgnmt table. |
LONG |
Yes |
Item Definition Id |
A Foreign Key to the Definition table. |
LONG |
No |
Item Id |
A Foreign Key to the Item table. |
LONG |
No |
Field Id |
A Foreign Key to the Definition table. |
LONG |
No |
Application User Id |
A Foreign Key to the Application User table. |
LONG |
No |
Team Id |
A Foreign Key to the Team table. |
LONG |
No |
CC Email Address |
Cannot be used with TeamId,App_user_id, can only be used with CC Assignment |
VARCHAR(255) |
No |
Assignment Type Id |
A Foreign Key to the Assignment Type table. |
INTEGER |
No |
Begin Date |
The value of a Assignment, stored as a date. |
DATE |
No |
End Date |
The value of a Assignment, stored as a date. |
DATE |
No |
Is Team |
Special clarifying field of "Is Team Level Assignment" to state that the Team does not have to be immediately resolved to a Team+Individual. |
BOOLEAN |
Yes |
Delete Transaction Id |
A unique incremental transaction identifier that indicates a soft delete. The id is generated via id generation, and may or may not correspond to the audit trail transaction id. This method of marking the soft delete allows for a unique index to be created on the Workspace Definition Id, Team Name, and Delete Transaction Id to enforce no duplicates in the live copies, and it allows multiple soft deleted rows with the same team name.
|
LONG |
No |
Sort Order |
The value of a Assignment stored as boolean. |
INTEGER |
No |