GPGB_P11D_MAP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	P11D_SOLUTION_ID	Character(10)	VARCHAR2(10) NOT NULL	P11D Solution ID
2	P11D_EXTRACT_ID	Character(10)	VARCHAR2(10) NOT NULL	P11D Extract ID
3	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: PSRECFIELDALL
5	P11D_COLUMN_HEAD	Character(50)	VARCHAR2(50) NOT NULL	P11D Column Heading
6	P11D_METHOD	Character(30)	VARCHAR2(30) NOT NULL	Holds name of Application Class Method.
7	P11D_CONSTANT	Character(30)	VARCHAR2(30) NOT NULL	Constant
8	P11D_INCLUDE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether field is included in the P11D Extract output file Y/N Table Edit Default Value: Y
9	P11D_DT_IN_TAX_YR	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate if date field falls within the tax year. 0=None 1=Specific date 2=Start date of period 3=End date of period Default Value: 0
10	P11D_XLAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Detrmines whether to use the code, short xlat description or long xlat description. 1=Code 2=Xlat Short Description 3=Xlat Long Description Default Value: 1
11	P11D_EXCLUDE_ROW	Character(1)	VARCHAR2(1) NOT NULL	Determines if row is excluded from output file. Y/N Table Edit Default Value: N