GPSG_IRAS1_AET (SQL Table)	Index Back
State record for IR8A/S Create State record for Singapore IR8A/S Create Process.

GPSG_IRAS1_AET

(SQL Table)

State record for IR8A/S Create

State record for Singapore IR8A/S Create Process.

# 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 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December

4 BALANCE_GRP_NUM Character(3) VARCHAR2(3) NOT NULL This field will be used to determine the grouping of balances from the different jobs of the employee.

#	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	MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
4	BALANCE_GRP_NUM	Character(3)	VARCHAR2(3) NOT NULL	This field will be used to determine the grouping of balances from the different jobs of the employee.