PROCESS_INSTANCEEMPLIDEMPL_RCDDURSEQ_NBRSEQNBRC=Calculated Record
E=Exception Record
H=Header Record
L=Line Record
TL_OPA_DECSRPT(SQL Table) |
Index Back |
|---|---|
Decision Report TableLRM OPA Rules Descision Report table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 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 | SEQNBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 8 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 9 | TL_REC_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Record Type
C=Calculated Record E=Exception Record H=Header Record L=Line Record |
| 10 | TL_OPA_CAL_INST | Character(50) | VARCHAR2(50) NOT NULL | OPA Calculated Instance |
| 11 | TL_OPA_REP_INST | Character(50) | VARCHAR2(50) NOT NULL | OPA Reported Instance |