GPIT_CIG_PREG (SQL Table)	Index Back
Setup CIG Approvals Setup CIG Approvals

GPIT_CIG_PREG

(SQL Table)

Setup CIG Approvals

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 FROM_DT Date(10) DATE NOT NULL From Date
Default Value: %Date

3 THRU_DT Date(10) DATE NOT NULL Sal Package - Thru Date
Default Value: %Date

4 GPIT_YEARCD1 Character(4) VARCHAR2(4) NOT NULL Year Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	FROM_DT	Date(10)	DATE NOT NULL	From Date Default Value: %Date
3	THRU_DT	Date(10)	DATE NOT NULL	Sal Package - Thru Date Default Value: %Date
4	GPIT_YEARCD1	Character(4)	VARCHAR2(4) NOT NULL	Year Code
5	GPIT_MONTHCD1	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