PROCESS_INSTANCEEMPLIDCAL_RUN_IDEMPL_RCDGP_PAYGROUPCAL_IDRSLT_SEG_NUMPIN_NUMGPCN_NRP_AWE_VW(SQL View) |
Index Back |
|---|---|
Segment Guide WASegment Guide WA could be used for extraction and reporting. |
| SELECT PROCESS_INSTANCE , EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , RSLT_SEG_NUM , PIN_NUM + 50000000 , PIN_CODE , PIN_NM , CALC_RSLT_VAL FROM PS_GPCN_AWE_RS |
| # | 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 |