UPG_GPMX830_AET (SQL Table)	Index Back
Upgrade Mexico 8.3-8.4 AET Default State Record for Mexico 8.3 to 8.4 Upgrade

UPG_GPMX830_AET

(SQL Table)

Upgrade Mexico 8.3-8.4 AET

Default State Record for Mexico 8.3 to 8.4 Upgrade

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

5 MED_REC_CD_MEX Character(3) VARCHAR2(3) NOT NULL Medic Region Code Mexico

6 AFORE_MEX Character(4) VARCHAR2(4) NOT NULL AFORE retirement Found code Mexico
0010=Allianz Dresdner
0020=Banamex Aegon
0030=Bancomer
0040=Garante
0050=Inbursa
0060=ING
0070=Principal
0080=Profuturo GNP
0090=Santander Mexicano
0100=Tepeyac
0110=XXI
0120=Zurich
0130=Banorte Generalli

7 SQL_ROW_COUNT Number(8,0) INTEGER NOT NULL Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
5	MED_REC_CD_MEX	Character(3)	VARCHAR2(3) NOT NULL	Medic Region Code Mexico
6	AFORE_MEX	Character(4)	VARCHAR2(4) NOT NULL	AFORE retirement Found code Mexico 0010=Allianz Dresdner 0020=Banamex Aegon 0030=Bancomer 0040=Garante 0050=Inbursa 0060=ING 0070=Principal 0080=Profuturo GNP 0090=Santander Mexicano 0100=Tepeyac 0110=XXI 0120=Zurich 0130=Banorte Generalli
7	SQL_ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.