GP_PYE_CAL(SQL Table) |
Index Back |
|---|---|
Payee in Calendar TransactionRecord identifies a single EE (RCD) and Calendar combination to be processed in an (Off-Cycle) absence or payroll process. Contains field to override calendar attributes that affect the processing. |
| # | 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 | GP_TX_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Type (introduced with Off-cycle). Identifies an offcycle request as correction,manual payment, unscheduled payment or advance.
XLAT values are assigned to support batch processing order
A=Advance M=Manual Payment R=Correction U=Additional Payment |
| 6 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 7 | GP_CORR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Identifies type of correction requested (in offcycle). See Translate values for set of types
N=Normal retro R=Replacement V=Reversal - Normal retro W=Reversal - Replacement Y=Year end adjustment |
| 8 | SEQ_NUM5 | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 9 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
| 10 | OFF_CYCLE_ID | Character(18) | VARCHAR2(18) NOT NULL | Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments |
| 11 | SRC_CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar ID |
| 12 | SRC_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Run ID |
| 13 | PYMT_DT | Date(10) | DATE | Payment Date |
| 14 | CALC_FROM_DT | Date(10) | DATE | Calculate From Date. Used to aid in calculating only a partial pay period |
| 15 | CALC_THRU_DT | Date(10) | DATE | Calculate Thru Date |
| 16 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 17 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 18 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 19 | PYMT_KEY1 | Character(25) | VARCHAR2(25) NOT NULL | Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number |
| 20 | PYMT_KEY2 | Character(25) | VARCHAR2(25) NOT NULL | Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number |
| 21 | PYMT_KEY3 | Character(25) | VARCHAR2(25) NOT NULL | Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number |
| 22 | PYMT_KEY4 | Character(25) | VARCHAR2(25) NOT NULL | Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number |
| 23 | GP_NO_REG_RES_IND | Character(1) | VARCHAR2(1) NOT NULL | Used to indicate that no element resolution is to take place except the processing of retro adjustment and PI. Introduced with Offcycle |
| 24 | PIN_ELEM_GRP_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number for Element Group |
| 25 | PAYMENT_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Payment Method
A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer |
| 26 | PYMT_ID | Character(6) | VARCHAR2(6) NOT NULL | Payment Identification |
| 27 | PYMT_NBR | Number(18,0) | DECIMAL(18) NOT NULL | Payment Number |
| 28 | PIN_GROSS_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Gross Pay Value |
| 29 | PIN_NET_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Net Pay Value |
| 30 | ISSUE_DT | Date(10) | DATE | Issue Date for Payment Reconciliation |
| 31 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 32 | PYMT_VALIDATE_IND | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates the Manual Payment validation status.
C=Validate at Calculation Time N=Not Validated V=Validated |
| 33 | GP_TX_REASON | Character(18) | VARCHAR2(18) NOT NULL | Off Cycle (Transaction) Reason Identifies a particular configuration to be applied to the presentation of off cycle request information |