PROCESS_INSTANCEEMPLIDCAL_RUN_IDEMPL_RCDGP_PAYGROUPCAL_IDORIG_CAL_RUN_IDRSLT_SEG_NUMRSLT_VER_NUMRSLT_REV_NUMPIN_NUMGP_RPT_KEYSLICE_BGN_DTSLICE_END_DTGPIN_PY_TMP4(SQL Table) |
Index Back |
|---|---|
Payee Report working tableWorking table for the Payee Report process run (preparation of the pay results for reporting). This table will hold the values of the Break Levels taken from the GP result Pin 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 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 6 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 7 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 8 | RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 9 | RSLT_VER_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Version Number |
| 10 | RSLT_REV_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Revision Number |
| 11 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 12 | GP_RPT_KEY |
Character(22) | VARCHAR2(22) NOT NULL | Output Result Key |
| 13 | SLICE_BGN_DT |
Date(10) | DATE | Element Slice Begin Date |
| 14 | SLICE_END_DT |
Date(10) | DATE | Element Slice End Date |
| 15 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 16 | CHR_PIN_VAL | Character(30) | VARCHAR2(30) NOT NULL | Calculation Character Result |