GP_NET_PAY1_VW(SQL View) |
Index Back |
|---|---|
Payment Net Pay generation tmpWork record used in the Payment Generation process. This view helps combine data in GP NET PAY1 TMP for same segment as input for the banking process that distributes pay according to payees instructions. It is IMPORTANT that these records are kept in sync. |
| SELECT CAL_RUN_ID ,EMPLID ,EMPL_RCD ,GP_PAYGROUP ,CAL_ID ,ORIG_CAL_RUN_ID ,RSLT_SEG_NUM ,PAY_ENTITY ,PYMT_KEY1 ,PYMT_KEY2 ,PYMT_KEY3 ,PYMT_KEY4 ,BUSINESS_UNIT ,RUN_TYPE ,ACCOUNT_ID ,SEG_END_DT ,MAX(PIN_NET_NUM) ,SUM(GP_PMT_AMT) ,CURRENCY_CD ,MIN(REVERSAL_IND) ,SRC_BANK_ID ,PAYMENT_MTHD ,CAL_PRD_ID ,RSLT_VER_NUM ,PRD_TYPE ,PYMT_ID ,PYMT_NBR FROM PS_GP_NET_PAY1_TMP GROUP BY CAL_RUN_ID ,EMPLID ,EMPL_RCD ,GP_PAYGROUP ,CAL_ID ,ORIG_CAL_RUN_ID ,RSLT_SEG_NUM ,PAY_ENTITY ,PYMT_KEY1 ,PYMT_KEY2 ,PYMT_KEY3 ,PYMT_KEY4 ,BUSINESS_UNIT ,RUN_TYPE ,ACCOUNT_ID ,SEG_END_DT ,CURRENCY_CD ,SRC_BANK_ID ,PAYMENT_MTHD ,CAL_PRD_ID ,RSLT_VER_NUM ,PRD_TYPE ,PYMT_ID ,PYMT_NBR HAVING SUM(GP_PMT_AMT)<>0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 5 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 6 | ORIG_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 7 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 8 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 9 | 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 |
| 10 | 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 |
| 11 | 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 |
| 12 | 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 |
| 13 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 14 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 15 | ACCOUNT_ID | Number(3,0) | SMALLINT NOT NULL | Account ID |
| 16 | SEG_END_DT | Date(10) | DATE | Payee Process Segment's End Date |
| 17 | PIN_NET_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 18 | GP_PMT_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount field on GP PAYMENT table |
| 19 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 20 | REVERSAL_IND | Number(1,0) | SMALLINT NOT NULL | Reversal Indicator. Used in the GP BANKING process to identify transactions that are reversals. 0 means not reversal, 1 means reversal. |
| 21 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID |
| 22 | 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 |
| 23 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
| 24 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
| 25 | PRD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Period Type
C=Current R=Retro |
| 26 | PYMT_ID | Character(6) | VARCHAR2(6) NOT NULL | Payment Identification |
| 27 | PYMT_NBR | Number(18,0) | DECIMAL(18) NOT NULL | Payment Number |