GPJP_YEA_SETUP (SQL Table)	Index Back
YEA Set up GPJP YEA SEt Up record

GPJP_YEA_SETUP

(SQL Table)

YEA Set up

GPJP YEA SEt Up record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DATE_YEAR_VAL Number(4,0) SMALLINT NOT NULL Date Year Value

2 ASOFDATE Date(10) DATE NOT NULL As of Date

3 DATE_FROM Date(10) DATE NOT NULL Date From

4 DATE_TO Date(10) DATE NOT NULL Previous Period Date To

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DATE_YEAR_VAL	Number(4,0)	SMALLINT NOT NULL	Date Year Value
2	ASOFDATE	Date(10)	DATE NOT NULL	As of Date
3	DATE_FROM	Date(10)	DATE NOT NULL	Date From
4	DATE_TO	Date(10)	DATE NOT NULL	Previous Period Date To