FA_RCD_NO_VW

(SQL View)
Index Back

FA Enrolled Employee View

FA 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