GPS_INSTALL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_05
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GPS_BDG_SYSTEM	Character(1)	VARCHAR2(1) NOT NULL	Budgeting System D=Doppik K=Kameralistik O=Other
4	GPS_CUTOFF_MNTH	Number(2,0)	SMALLINT NOT NULL	Month of Cut Off Date used in German Public Sector Default Value: 1
5	GPS_CUTOFF_DAY	Number(2,0)	SMALLINT NOT NULL	Day part of Cut Off Date used in German Public Sector Default Value: 1
6	GPS_USE_APPR_PNDG	Character(1)	VARCHAR2(1) NOT NULL	Use Approve Pending N=No Y=Yes Y/N Table Edit Default Value: N
7	GPS_LAYOUT_IND	Character(1)	VARCHAR2(1) NOT NULL	P or F percentage or fraction values will be used for display. The system always stores a decimal value but recalculates if the user had chosen to display a percentage. F=Fractional P=Percentage Default Value: F
8	GPS_REMK_EXE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Used to select the remark execution type A=Automatic M=Manual Default Value: M
9	GPS_POST_ID_LST	Character(8)	VARCHAR2(8) NOT NULL	GPS post id Default Value: 0
10	GPS_REMARKID_LST	Character(8)	VARCHAR2(8) NOT NULL	GPS post id Default Value: 0
11	GPS_ORG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Organization Type. There are two possible values for this field. They are: G AND C C=Local Government G=National Government Default Value: G
12	GPS_2YR_PLAN	Character(1)	VARCHAR2(1) NOT NULL	Double Houshold Y/N Table Edit Default Value: N