Att_Inc_Action_Codes_Mapping (ver20.4.0)
This Many-to-Many associative table contains all the incident action codes that belong to one or more attendance codes.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Attendance_Code_DCID | 20.4.0 | Number(19,0) | Attendance Code identifier (DCID) with which this record is associated. Indexed with Lu_Sub_Code_ID. |
Is_Default | 20.4.0 | Number(1,0) | Indicates whether the referenced Attendance_Code_Dcid is the default attendance code for the Incident action code. Valid values: 1=True, 0=False. Default 0. Required. |
Lu_Sub_Code_ID | 20.4.0 | Number(19,0) | Incident Subcode identifier (LU_SUB_CODE_ID) with which this record is associated. Indexed with Attendance_Code_DCID. |
WhenCreated | 20.4.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 20.4.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 20.4.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 20.4.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |