GP_PKG_ADSO_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	RECNAME_EXPORT	Character(15)	VARCHAR2(15) NOT NULL	Export Record (Table) Name
5	RECNAME_ADS_EXPORT	Character(15)	VARCHAR2(15) NOT NULL	ADS Staging Record Name
6	EFFDT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	"Effective" Date Type. Indicates what type of date fields manages the effective date span on a given table. Used with managing triggers. Has codeset (XLAT values). E=Effective Date N=Not Effective Dated S=Begin - End Date
7	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
8	EFFDT	Date(10)	DATE	Effective Date
9	GP_VERSION_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether version-based. N=Regular Rule Package Y=Version Rule Package
10	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
11	RECNAME_TMP	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name
12	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
13	TEMP_FLD2	Character(1)	VARCHAR2(1) NOT NULL	For App Engine FGHR002B
14	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.
15	PROJECTNAME	Character(30)	VARCHAR2(30) NOT NULL	Project Name (see PSPROJECTDEFN).
16	GP_PKG_COMPARE_RPT	Character(1)	VARCHAR2(1) NOT NULL	Checkbox to indicator whether or not the Rules Package Compare Report should run as part of the Rules Compare process.
17	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
18	GRP_WHERE_CLS	Long Character(4096)	CLOB	Where Clause for Groups
19	RELLANGRECNAME	Character(15)	VARCHAR2(15) NOT NULL	Related Language Record Name
20	AE_TEST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Test Flag