FA_COMP_HDR (SQL Table)	Index Back
Header record for fee compare This is the header record for fee comparison.

FA_COMP_HDR

(SQL Table)

Header record for fee compare

This is the header record for fee comparison.

Related Language Record: FA_COMP_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
Prompt Table: BANK_CD_ACTIVE

3 SCENARIO Character(10) VARCHAR2(10) NOT NULL A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

5 FA_START_DT Date(10) DATE The date used for the start of the period. This date is defaulted to the first of the month for monthly analysis statements since it is not provided for those types. It is explicitly provided for statements that arrive off cycle or on a different period.

6 FA_END_DT Date(10) DATE The date used for the end of the period. This date is provided in the statement no matter what cycle the statements are on (EG Monthly or otherwise). If monthly, it is the last day of the month.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_ACTIVE
3	SCENARIO	Character(10)	VARCHAR2(10) NOT NULL	A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	FA_START_DT	Date(10)	DATE	The date used for the start of the period. This date is defaulted to the first of the month for monthly analysis statements since it is not provided for those types. It is explicitly provided for statements that arrive off cycle or on a different period.
6	FA_END_DT	Date(10)	DATE	The date used for the end of the period. This date is provided in the statement no matter what cycle the statements are on (EG Monthly or otherwise). If monthly, it is the last day of the month.