CN_SRP_ASGN_1006_TRANS
This table uses to store credit participants for participant assignment
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TRANS_OBJECT_ID | NUMBER | Yes | TRANS_OBJECT_ID | ||
EVENT_DATE | DATE | EVENT_DATE | |||
START_DATE | DATE | Start Date of the participant | |||
END_DATE | DATE | End Date of the participant | |||
WORKER_ID | NUMBER | WORKER_ID | |||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
ASSIGNED_OBJECT_ID | NUMBER | Yes | ASSIGNED_OBJECT_ID | ||
SQUAL_FC01 | VARCHAR2 | 3 | SQUAL_FC01 | ||
SQUAL_CURC01 | VARCHAR2 | 30 | SQUAL_CURC01 | ||
SQUAL_CHAR01 | VARCHAR2 | 360 | SQUAL_CHAR01 | ||
SQUAL_CHAR02 | VARCHAR2 | 360 | SQUAL_CHAR02 | ||
SQUAL_CHAR03 | VARCHAR2 | 360 | SQUAL_CHAR03 | ||
SQUAL_CHAR04 | VARCHAR2 | 360 | SQUAL_CHAR04 | ||
SQUAL_CHAR05 | VARCHAR2 | 360 | SQUAL_CHAR05 | ||
SQUAL_CHAR06 | VARCHAR2 | 360 | SQUAL_CHAR06 | ||
SQUAL_CHAR07 | VARCHAR2 | 360 | SQUAL_CHAR07 | ||
SQUAL_CHAR08 | VARCHAR2 | 360 | SQUAL_CHAR08 | ||
SQUAL_CHAR09 | VARCHAR2 | 360 | SQUAL_CHAR09 | ||
SQUAL_CHAR10 | VARCHAR2 | 360 | SQUAL_CHAR10 | ||
SQUAL_NUM01 | NUMBER | SQUAL_NUM01 | |||
SQUAL_NUM02 | NUMBER | SQUAL_NUM02 | |||
SQUAL_NUM03 | NUMBER | SQUAL_NUM03 | |||
SQUAL_NUM04 | NUMBER | SQUAL_NUM04 | |||
SQUAL_NUM05 | NUMBER | SQUAL_NUM05 | |||
SQUAL_FC02 | VARCHAR2 | 3 | SQUAL_FC02 | ||
SQUAL_CURC02 | VARCHAR2 | 30 | SQUAL_CURC02 | ||
SQUAL_CHAR11 | VARCHAR2 | 360 | SQUAL_CHAR11 | ||
SQUAL_CHAR12 | VARCHAR2 | 360 | SQUAL_CHAR12 | ||
SQUAL_CHAR13 | VARCHAR2 | 360 | SQUAL_CHAR13 | ||
SQUAL_CHAR14 | VARCHAR2 | 360 | SQUAL_CHAR14 | ||
SQUAL_CHAR15 | VARCHAR2 | 360 | SQUAL_CHAR15 | ||
SQUAL_CHAR16 | VARCHAR2 | 360 | SQUAL_CHAR16 | ||
SQUAL_CHAR17 | VARCHAR2 | 360 | SQUAL_CHAR17 | ||
SQUAL_CHAR18 | VARCHAR2 | 360 | SQUAL_CHAR18 | ||
SQUAL_CHAR19 | VARCHAR2 | 360 | SQUAL_CHAR19 | ||
SQUAL_CHAR20 | VARCHAR2 | 360 | SQUAL_CHAR20 | ||
SQUAL_NUM06 | NUMBER | SQUAL_NUM06 | |||
SQUAL_NUM07 | NUMBER | SQUAL_NUM07 | |||
SQUAL_NUM08 | NUMBER | SQUAL_NUM08 | |||
SQUAL_NUM09 | NUMBER | SQUAL_NUM09 | |||
SQUAL_NUM10 | NUMBER | SQUAL_NUM10 | |||
SQUAL_FC03 | VARCHAR2 | 3 | SQUAL_FC03 | ||
SQUAL_CURC03 | VARCHAR2 | 30 | SQUAL_CURC03 | ||
SQUAL_CHAR21 | VARCHAR2 | 360 | SQUAL_CHAR21 | ||
SQUAL_CHAR22 | VARCHAR2 | 360 | SQUAL_CHAR22 | ||
SQUAL_CHAR23 | VARCHAR2 | 360 | SQUAL_CHAR23 | ||
SQUAL_CHAR24 | VARCHAR2 | 360 | SQUAL_CHAR24 | ||
SQUAL_CHAR25 | VARCHAR2 | 360 | SQUAL_CHAR25 | ||
SQUAL_CHAR26 | VARCHAR2 | 360 | SQUAL_CHAR26 | ||
SQUAL_CHAR27 | VARCHAR2 | 360 | SQUAL_CHAR27 | ||
SQUAL_CHAR28 | VARCHAR2 | 360 | SQUAL_CHAR28 | ||
SQUAL_CHAR29 | VARCHAR2 | 360 | SQUAL_CHAR29 | ||
SQUAL_CHAR30 | VARCHAR2 | 360 | SQUAL_CHAR30 | ||
SQUAL_NUM11 | NUMBER | SQUAL_NUM11 | |||
SQUAL_NUM12 | NUMBER | SQUAL_NUM12 | |||
SQUAL_NUM13 | NUMBER | SQUAL_NUM13 | |||
SQUAL_NUM14 | NUMBER | SQUAL_NUM14 | |||
SQUAL_NUM15 | NUMBER | SQUAL_NUM15 | |||
SQUAL_FC04 | VARCHAR2 | 3 | SQUAL_FC04 | ||
SQUAL_CURC04 | VARCHAR2 | 30 | SQUAL_CURC04 | ||
SQUAL_CHAR31 | VARCHAR2 | 360 | SQUAL_CHAR31 | ||
SQUAL_CHAR32 | VARCHAR2 | 360 | SQUAL_CHAR32 | ||
SQUAL_CHAR33 | VARCHAR2 | 360 | SQUAL_CHAR33 | ||
SQUAL_CHAR34 | VARCHAR2 | 360 | SQUAL_CHAR34 | ||
SQUAL_CHAR35 | VARCHAR2 | 360 | SQUAL_CHAR35 | ||
SQUAL_CHAR36 | VARCHAR2 | 360 | SQUAL_CHAR36 | ||
SQUAL_CHAR37 | VARCHAR2 | 360 | SQUAL_CHAR37 | ||
SQUAL_CHAR38 | VARCHAR2 | 360 | SQUAL_CHAR38 | ||
SQUAL_CHAR39 | VARCHAR2 | 360 | SQUAL_CHAR39 | ||
SQUAL_CHAR40 | VARCHAR2 | 360 | SQUAL_CHAR40 | ||
SQUAL_NUM16 | NUMBER | SQUAL_NUM16 | |||
SQUAL_NUM17 | NUMBER | SQUAL_NUM17 | |||
SQUAL_NUM18 | NUMBER | SQUAL_NUM18 | |||
SQUAL_NUM19 | NUMBER | SQUAL_NUM19 | |||
SQUAL_NUM20 | NUMBER | SQUAL_NUM20 | |||
SQUAL_FC05 | VARCHAR2 | 3 | SQUAL_FC05 | ||
SQUAL_CURC05 | VARCHAR2 | 30 | SQUAL_CURC05 | ||
SQUAL_NUM21 | NUMBER | SQUAL_NUM21 | |||
SQUAL_NUM22 | NUMBER | SQUAL_NUM22 | |||
SQUAL_NUM23 | NUMBER | SQUAL_NUM23 | |||
SQUAL_NUM24 | NUMBER | SQUAL_NUM24 | |||
SQUAL_NUM25 | NUMBER | SQUAL_NUM25 | |||
SQUAL_DATE01 | DATE | SQUAL_DATE01 | |||
SQUAL_DATE02 | DATE | SQUAL_DATE02 | |||
SQUAL_DATE03 | DATE | SQUAL_DATE03 | |||
SQUAL_DATE04 | DATE | SQUAL_DATE04 | |||
SQUAL_DATE05 | DATE | SQUAL_DATE05 | |||
SQUAL_DATE06 | DATE | SQUAL_DATE06 | |||
SQUAL_DATE07 | DATE | SQUAL_DATE07 | |||
SQUAL_DATE08 | DATE | SQUAL_DATE08 | |||
SQUAL_DATE09 | DATE | SQUAL_DATE09 | |||
SQUAL_DATE10 | DATE | SQUAL_DATE10 | |||
SQUAL_DATE11 | DATE | SQUAL_DATE11 | |||
SQUAL_DATE12 | DATE | SQUAL_DATE12 | |||
SQUAL_DATE13 | DATE | SQUAL_DATE13 | |||
SQUAL_DATE14 | DATE | SQUAL_DATE14 | |||
SQUAL_DATE15 | DATE | SQUAL_DATE15 | |||
SQUAL_DATE16 | DATE | SQUAL_DATE16 | |||
SQUAL_DATE17 | DATE | SQUAL_DATE17 | |||
SQUAL_DATE18 | DATE | SQUAL_DATE18 | |||
SQUAL_DATE19 | DATE | SQUAL_DATE19 | |||
SQUAL_DATE20 | DATE | SQUAL_DATE20 | |||
SQUAL_NUM26 | NUMBER | SQUAL_NUM26 | |||
SQUAL_NUM27 | NUMBER | SQUAL_NUM27 | |||
SQUAL_NUM28 | NUMBER | SQUAL_NUM28 | |||
SQUAL_NUM29 | NUMBER | SQUAL_NUM29 | |||
SQUAL_NUM30 | NUMBER | SQUAL_NUM30 | |||
SQUAL_NUM31 | NUMBER | SQUAL_NUM31 | |||
SQUAL_NUM32 | NUMBER | SQUAL_NUM32 | |||
SQUAL_NUM33 | NUMBER | SQUAL_NUM33 | |||
SQUAL_NUM34 | NUMBER | SQUAL_NUM34 | |||
SQUAL_NUM35 | NUMBER | SQUAL_NUM35 | |||
SQUAL_NUM36 | NUMBER | SQUAL_NUM36 | |||
SQUAL_NUM37 | NUMBER | SQUAL_NUM37 | |||
SQUAL_NUM38 | NUMBER | SQUAL_NUM38 | |||
SQUAL_NUM39 | NUMBER | SQUAL_NUM39 | |||
SQUAL_NUM40 | NUMBER | SQUAL_NUM40 |