GPMX_ANNL_TMP (SQL Table)	Index Back
Multiple Information Temporary Multiple Information Temporary Table for Fomat 37 and DIM Legal Reports

GPMX_ANNL_TMP

(SQL Table)

Multiple Information Temporary

Multiple Information Temporary Table for Fomat 37 and DIM Legal Reports

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

5 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)

6 PIN_MBR_NUM Number(8,0) INTEGER NOT NULL Element number field

7 BGN_DT Date(10) DATE Begin Date

8 END_DT Date(10) DATE end date

9 ACM_SIGN Character(1) VARCHAR2(1) NOT NULL Accumulator Sign
A=Add
S=Subtract

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
5	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)
6	PIN_MBR_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
7	BGN_DT	Date(10)	DATE	Begin Date
8	END_DT	Date(10)	DATE	end date
9	ACM_SIGN	Character(1)	VARCHAR2(1) NOT NULL	Accumulator Sign A=Add S=Subtract