TC_DEPTSEC_EMPL(SQL View) |
Index Back |
|---|---|
TC Depatement Security ViewTC Security View used in Query Views TCDEPTQUERYWITHEEx |
| SELECT A.DEPTID , A.EMPLID , B.NAME , A.BUSINESS_UNIT , A.EFFDT FROM PS_JOB A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 2 | TREE_NODE_CHILD | Character(20) | VARCHAR2(20) NOT NULL | Tree Node Child |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | EFFDT | Date(10) | DATE | Effective Date |