GM_PRJ_TITLE_VW(SQL View) |
Index Back |
|---|---|
Grants Project Title ViewGrants Project Title View of GM_DEPT_CNT_TYP record. GM_DEPT_CNT_TYP provides the official type field to be related displayed as the department title |
| SELECT A.BUSINESS_UNIT, A.PROJECT_ID, A.DEPTID,A.EMPLID, B.OFFICIAL_TYPE FROM PS_GM_PRJ_DEPT A, PS_GM_DEPT_CNT_TYP B WHERE B.SETID=(SELECT SETID FROM PS_SET_CNTRL_REC G WHERE G.SETCNTRLVALUE=A.BUSINESS_UNIT AND G.RECNAME='GM_DEPT_CNT_TYP') AND A.DEPTID = B.DEPTID AND A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT_VW |
| 3 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: GM_DEPT_TBL_VW |
| 4 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | OFFICIAL_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Official Type
ADM=Administrative Official BUS=Business Officer CEO=Chief Executive Officer DEA=Dean DEP=Department Administrator HEA=Department Head IO=Institution Officer PRO=Provost PRS=President REP=Authorized Inst. Rep/Payee SEN=Senior Official |