TV_GRP_TRVLR_VW(SQL View) |
Index Back |
---|
SELECT BUSINESS_UNIT_GL , DEPTID , EMPLID FROM PS_TV_TVLR_ASGN_VW |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
2 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: EX_EE_DEPT_VW |