EXCEPTION_IDEMPLIDEMPL_RCDDURSEQ_NBRPROCESS_INSTANCERUN_CNTL_IDLANGUAGE_CDTL_EXCEPT_LANG(SQL Table) |
Index Back |
|---|---|
T&L Exception Related LanguageThis table stores up to one occurence of a specific Exception per Employee & Record Number per day. Time Administration and Time Validation processes produce and resolve exceptions, based on system defined validations, as well as user defined rules or validations. Time Management events enable users to View Exceptions, Allow Exceptions and resolve the conditions which cause exceptions. This table supports comments being added to the exception in multiple languages, via the Time Management events. This requirement appears to be one that is possible, but should occur infrequently. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXCEPTION_ID |
Character(8) | VARCHAR2(8) NOT NULL | Exception ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | DUR |
Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 5 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 7 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 8 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 9 | MSG_DATA1 | Character(100) | VARCHAR2(100) NOT NULL | Message Data Text 1 |
| 10 | MSG_DATA2 | Character(100) | VARCHAR2(100) NOT NULL | Message Data Text 2 |
| 11 | MSG_DATA3 | Character(100) | VARCHAR2(100) NOT NULL | Message Data Text 3 |
| 12 | MSG_DATA4 | Character(100) | VARCHAR2(100) NOT NULL | Message Data Text 4 |
| 13 | MSG_DATA5 | Character(100) | VARCHAR2(100) NOT NULL | Message Data Text 5 |
| 14 | COMMENTS | Long Character | CLOB | Comment |