UPG_GPCNPIN_AET (SQL Table)	Index Back
State Record for AE-UPG_GPCN91 State Record for AE--UPG_GPCN91

UPG_GPCNPIN_AET

(SQL Table)

State Record for AE-UPG_GPCN91

State Record for AE--UPG_GPCN91

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 PIN_ACCT_STATUS Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

3 PIN_ACCT_CHG Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

4 PIN_ACOUNT_NUM Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

5 PIN_CONTRIB_AREA Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

6 PIN_CONT_METHOD Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

7 PIN_PHFSI_PRBN_YN Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

8 PIN_PHFSI_TERM_YN Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

9 PIN_CONT_BASE_EE1 Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

10 PIN_CONT_BASE_EE2 Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

11 PIN_CONT_BASE_EE3 Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

12 PIN_CONT_BASE_EE4 Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

13 PIN_CONT_BASE_EE5 Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

14 PIN_CONT_BASE_EE6 Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

15 PIN_CONT_BASE_EE7 Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

16 PIN_CONT_BASE_EE8 Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For GPCHN.

17 PIN_CONT_BASE_EE9 Number(8,0) INTEGER NOT NULL Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PIN_ACCT_STATUS	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
3	PIN_ACCT_CHG	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
4	PIN_ACOUNT_NUM	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
5	PIN_CONTRIB_AREA	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
6	PIN_CONT_METHOD	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
7	PIN_PHFSI_PRBN_YN	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
8	PIN_PHFSI_TERM_YN	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
9	PIN_CONT_BASE_EE1	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
10	PIN_CONT_BASE_EE2	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
11	PIN_CONT_BASE_EE3	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
12	PIN_CONT_BASE_EE4	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
13	PIN_CONT_BASE_EE5	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
14	PIN_CONT_BASE_EE6	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
15	PIN_CONT_BASE_EE7	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.
16	PIN_CONT_BASE_EE8	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For GPCHN.
17	PIN_CONT_BASE_EE9	Number(8,0)	INTEGER NOT NULL	Save an specific PIN_NUM value from PS_GP_PIN. For AE --- UPG_GPCN91.