PERORGASGFA_CV (SQL View)	Index Back
PER_ORG_ASG_FA MSG Clairvia Clone of PER_ORG_ASG_FA record for Clairvia Fullsync message

PERORGASGFA_CV

(SQL View)

PER_ORG_ASG_FA MSG Clairvia

Clone of PER_ORG_ASG_FA record for Clairvia Fullsync message

SELECT FA.EMPLID , FA.EMPL_RCD , FA.FA_PAY_PROGRAM , FA.FA_TYPE , FA.FA_ELIG_DT FROM PS_PER_ORG_ASG_FA FA , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = FA.EMPLID AND ASG.EMPL_RCD = FA.EMPL_RCD AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: PER_ORG_ASGN.EMPLID
Prompt Table: PER_ORG_ASGN

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Default Value: PER_ORG_ASGN.EMPL_RCD
Prompt Table: PER_ORG_ASGN

3 FA_PAY_PROGRAM Character(3) VARCHAR2(3) NOT NULL Festive Advance Pay Program that the Employee is enrolled in.
Prompt Table: FA_PAY_HDR

4 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
Default Value: N

5 FA_ELIG_DT Date(10) DATE Festive Advance Eligibility Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PER_ORG_ASGN.EMPLID Prompt Table: PER_ORG_ASGN
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: PER_ORG_ASGN.EMPL_RCD Prompt Table: PER_ORG_ASGN
3	FA_PAY_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Festive Advance Pay Program that the Employee is enrolled in. Prompt Table: FA_PAY_HDR
4	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 Default Value: N
5	FA_ELIG_DT	Date(10)	DATE	Festive Advance Eligibility Date