BUSINESS_UNITDefault Value: PROJECT.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW
PROJECT_IDDefault Value: PROJECT_VW.PROJECT_ID
Prompt Table: GM_DEPT_TBL_VW
Prompt Table: GM_DEPT_CNTCT_V
Prompt Table: GM_DEPT_TBL_VW
Prompt Table: GM_INSTITUTION
GM_PRJ_DEPT(SQL Table) |
Index Back |
|---|---|
Grants Project Department ContThis record stores grants project contact data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJECT.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: PROJECT_VW.PROJECT_ID |
| 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
Prompt Table: GM_DEPT_CNTCT_V |
| 5 | MAJOR_SUBDIVISION | Character(10) | VARCHAR2(10) NOT NULL |
Major Subdivision ID
Prompt Table: GM_DEPT_TBL_VW |
| 6 | INSTID | Character(5) | VARCHAR2(5) NOT NULL |
Institution ID
Prompt Table: GM_INSTITUTION |