GP_ABS_NRP_PIVW(SQL View) |
Index Back |
|---|---|
AM Create Payroll Interf FileAbsence Management Create Payroll Interface File - NRP View |
| SELECT EMPLID , EMPL_RCD , GP_PAYGROUP , CAL_ID , SRC_CAL_ID , PI_VER_NUM , PIN_NUM + 50000000 , PI_SOURCE , GEN_INSTANCE , END_DT , BGN_DT , SRC_CAL_RUN_ID , PAY_SYSTEM_FLG , COMPANY , PAYGROUP , PI_FIELD_VALUE , PIN_CODE , PIN_NM , PI_ACTION_TYPE , CURRENCY_CD , RATE_ASOF_DATE , GP_RATE , GP_UNIT , GP_BASE , GP_PCT , GP_AMT , BUSINESS_UNIT , DESCR , ABS_PRD_BGN_DT , ABS_PRD_END_DT , ABS_BGN_DT , ABS_END_DT FROM PS_GP_ABS_PAY_INTF |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 4 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 5 | SRC_CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | Source Calendar ID |
| 6 | PI_VER_NUM |
Number(3,0) | SMALLINT NOT NULL | PI version number |
| 7 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 8 | PI_SOURCE |
Character(1) | VARCHAR2(1) NOT NULL |
Positive Input Source
A=Absence G=Generated PI M=Manual T=Time&Labor |
| 9 | GEN_INSTANCE |
Number(4,0) | SMALLINT NOT NULL | Instance of Generated PI |
| 10 | END_DT |
Date(10) | DATE | end date |
| 11 | BGN_DT | Date(10) | DATE | Begin Date |
| 12 | SRC_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Run ID |
| 13 | PAY_SYSTEM_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface |
| 14 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 15 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 16 | PI_FIELD_VALUE | Character(10) | VARCHAR2(10) NOT NULL | PYI Field Conversion Value |
| 17 | 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) |
| 18 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 19 | PI_ACTION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Action Type Positive Input
A=Add I=Ignore N=Do Not Process O=Override Z=Resolve To Zero |
| 20 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 21 | RATE_ASOF_DATE | Date(10) | DATE | As Of Date for PI Rate |
| 22 | GP_RATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate |
| 23 | GP_UNIT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Unit |
| 24 | GP_BASE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Base |
| 25 | GP_PCT | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Percent |
| 26 | GP_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount |
| 27 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 28 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 29 | ABS_PRD_BGN_DT | Date(10) | DATE | Absence Period Begin Date |
| 30 | ABS_PRD_END_DT | Date(10) | DATE | Absence Period End Date |
| 31 | ABS_BGN_DT | Date(10) | DATE | Absence Begin Date |
| 32 | ABS_END_DT | Date(10) | DATE | Absence End Date |