PROCESS_INSTANCEEMPLIDCAL_RUN_IDEMPL_RCDGP_PAYGROUPCAL_IDRSLT_SEG_NUMPIN_NUMGPCN_AWE_RS(SQL Table) |
Index Back |
|---|---|
Result for Payroll AWEThis is the record that will be used to store all the data which will be used to generate reports |
| # | 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 | RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 8 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 9 | PIN_CODE | Character(22) | VARCHAR2(22) NOT NULL | Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN) |
| 10 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 11 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |