GPS_BDG_SYSTEM (SQL Table)	Index Back
Budgeting System The budgeting system that is used by a tennant and it's basic definitions. Stored are a separator that should be used, the amount of levels that aply to this budgeting system and the description of it. Examples are 'K' for Kameralistik. Separator used is a dot (.). The Kameralisik system consists of 3 levels. The single plan, the chapter and the title.

GPS_BDG_SYSTEM

(SQL Table)

Budgeting System

The budgeting system that is used by a tennant and it's basic definitions. Stored are a separator that should be used, the amount of levels that aply to this budgeting system and the description of it. Examples are 'K' for Kameralistik. Separator used is a dot (.). The Kameralisik system consists of 3 levels. The single plan, the chapter and the title.

Related Language Record: GPS_BDG_SYS_LNG

# 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 GPS_BDG_SYSTEM Character(1) VARCHAR2(1) NOT NULL Budgeting System
D=Doppik
K=Kameralistik
O=Other

3 SEPARATOR Character(1) VARCHAR2(1) NOT NULL TS130 field separator.

4 GPS_LEVELS Number(1,0) SMALLINT NOT NULL amount of levels

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	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	GPS_BDG_SYSTEM	Character(1)	VARCHAR2(1) NOT NULL	Budgeting System D=Doppik K=Kameralistik O=Other
3	SEPARATOR	Character(1)	VARCHAR2(1) NOT NULL	TS130 field separator.
4	GPS_LEVELS	Number(1,0)	SMALLINT NOT NULL	amount of levels
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50