FA_DTLS_HDR (SQL Table)	Index Back
FA Payment Header Details Festive Advance Payment Header Details table. Parent for FA_PAYMENTS record

FA_DTLS_HDR

(SQL Table)

FA Payment Header Details

Festive Advance Payment Header Details table. Parent for FA_PAYMENTS record

Parent Record Of FA_PAYMENTS GPSG_NRP_FA2_AD GPSG_NRP_FA2_VW

# 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
Prompt Table: COMPANY_TBL

3 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
Prompt Table: PAYGROUP_TBL

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

#	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 Prompt Table: COMPANY_TBL
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
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 Default Value: N