FA_RCD_NO_VW(SQL View) |
Index Back |
---|---|
FA Enrolled Employee ViewFA Enrolled Employee View |
SELECT A.GP_PAYGROUP ,A.COMPANY ,A.PAYGROUP ,A.EMPLID ,A.EMPL_RCD ,B.FA_TYPE ,B.FA_PAY_PROGRAM ,B.FA_ELIG_DT FROM PS_JOB A , PS_PER_ORG_ASG_FA B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EMPL_STATUS = 'A' AND B.FA_TYPE <> ' ' AND B.FA_PAY_PROGRAM <> ' ' AND B.FA_ELIG_DT < %CurrentDateIn AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.EFFDT <=%CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(E.EFFSEQ) FROM PS_JOB E WHERE E.EMPLID = A.EMPLID AND E.EMPL_RCD = A.EMPL_RCD AND E.EFFDT = A.EFFDT) |
# | 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
6 | 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 |
7 | FA_PAY_PROGRAM | Character(3) | VARCHAR2(3) NOT NULL | Festive Advance Pay Program that the Employee is enrolled in. |
8 | FA_ELIG_DT | Date(10) | DATE | Festive Advance Eligibility Date |