GPSG_NRP_FA2_VW(SQL View) |
Index Back |
|---|---|
FA Payment DetailsFestive Advance Payment details record for the Employee. |
| SELECT GP_PAYGROUP ,COMPANY ,PAYGROUP ,CALENDAR_YEAR ,FA_TYPE ,EMPLID ,EMPL_RCD ,PLAN_TYPE ,DEDCD ,ERNCD ,FA_AMOUNT ,FA_STATUS ,PAY_END_DT ,EFFDT ,OFF_CYCLE ,PIN_ERN_NUM + 50000000 FROM PS_FA_PAYMENTS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: HR_GP_PYGRP_VW |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 4 | CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 5 | FA_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
This field will define the Festive Advance Holiday Type.
CHR=Christmas CNY=Chinese New Year DEP=Deepavali HAR=Hari Raya N=Value Not Applicable |
| 6 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: %EDITTABLE |
| 7 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 8 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 9 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table: DEDUCTION_TBL |
| 10 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: EARNINGS_TBL |
| 11 | FA_AMOUNT | Number(16,2) | DECIMAL(15,2) NOT NULL | Festive Advance Payment Amount |
| 12 | FA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Festive Advance Payment Status
A=Approved N=Not Approved P=Posted |
| 13 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 14 | EFFDT | Date(10) | DATE | Effective Date |
| 15 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 16 | PIN_ERN_NUM | Number(8,0) | INTEGER NOT NULL |
Pin Number Earning
Prompt Table: GP_ERN_SRCH |