GP_PKG_ADSM_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
4	GP_PKG_ID_TO	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
5	GP_RULE_PKG_ID_TO	Character(10)	VARCHAR2(10) NOT NULL	Package ID
6	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
7	RECNAME_ADS_EXPORT	Character(15)	VARCHAR2(15) NOT NULL	ADS Staging Record Name
8	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
9	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
10	GP_VERSION_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether version-based. N=Regular Rule Package Y=Version Rule Package
11	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
12	GPDBNAME	Character(8)	VARCHAR2(8) NOT NULL	Database name where Package is created.
13	ONE_MATCH_LBL	Character(1)	VARCHAR2(1) NOT NULL	One Match
14	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
15	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
16	WHERE_LONG	Long Character	CLOB	Where Clause
17	PIN_CODE	Character(22)	VARCHAR2(22) NOT NULL	Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
18	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
19	PIN_NUM_LAST	Number(8,0)	INTEGER NOT NULL	Last Used Element Number
20	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description