GP_ABS_PAY_INTF(SQL Table) |
Index Back |
|---|---|
AM to Payroll Interface FileAbsence Management to Payroll Interface - Output File |
| # | 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 Rcd Nbr |
| 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(3,0) | SMALLINT NOT NULL | Instance of Generated PI |
| 10 | END_DT |
Date(10) | DATE | end date |
| 11 | SRC_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Run ID |
| 12 | GP_UNIT |
Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Unit |
| 13 | BGN_DT | Date(10) | DATE | Begin Date |
| 14 | PAY_SYSTEM_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface |
| 15 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 16 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 17 | PI_FIELD_VALUE | Character(10) | VARCHAR2(10) NOT NULL | PYI Field Conversion Value |
| 18 | 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) |
| 19 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 20 | 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 |
| 21 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 22 | RATE_ASOF_DATE | Date(10) | DATE | As Of Date for PI Rate |
| 23 | GP_RATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate |
| 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 |