GP_PINMAP_C_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	RUNTIME	Time(15)	TIMESTAMP	Process Scheduler Process Run Time
4	ERROR_CNT	Number(4,0)	SMALLINT NOT NULL	Error Count
5	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
6	FIELD_COUNTER	Number(7,0)	INTEGER NOT NULL	Field Counter
7	PIN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Element Type
8	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
9	PIN_MBR_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
10	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
11	FIELDNAME_KEY1	Character(18)	VARCHAR2(18) NOT NULL	Field created for use with element packager
12	FIELDNAME_KEY2	Character(18)	VARCHAR2(18) NOT NULL	Field created for use with element packager
13	FLD_MAP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Field Status I=Invalid V=Valid
14	FLDMAP_RECNUM_KEY	Number(9,0)	DECIMAL(9) NOT NULL	Record # identifier Key
15	FLDMAP_FLDNUM_KEY1	Number(9,0)	DECIMAL(9) NOT NULL	Field Number Key Identifier 1
16	FLDMAP_FLDNUM_KEY2	Number(9,0)	DECIMAL(9) NOT NULL	Field Number Key Identifier 2
17	RECORD_TYPE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Record Type N=Setup Definition O=Output Result Data P=Payee Data R=Element Definition
18	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
19	RECNAME_EXPORT	Character(15)	VARCHAR2(15) NOT NULL	Export Record (Table) Name
20	FLDNAME_1	Character(18)	VARCHAR2(18) NOT NULL	Field 1 Name
21	ALIAS_NAME	Character(10)	VARCHAR2(10) NOT NULL	Alias Name
22	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field