GPS_IN_BEHALF(SQL Table) |
Index Back |
---|---|
In Behalf Of tableGerman 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 |