GPS_IN_BEHALF

(SQL Table)
Index Back

In Behalf Of table

German Public Sector In behalf of table, used for populate the ob behalf of field

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 GPS_NAME_TYPE Character(1) VARCHAR2(1) NOT NULL Name type used in on behalf of page, possible values are: E- Employee,O- Other
E=Employee
O=Other

Default Value: E

4 GPS_DELEGATOR_ID Character(11) VARCHAR2(11) NOT NULL On behalf of employee id

Prompt Table: GPS_EMPL_NAM_VW

5 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country