BUSINESS_UNITCONTRACT_NUMSUB_PROP_NBRN=No
Y=Yes
GM_CNT_JHDR_VW(SQL View) |
Index Back |
|---|---|
GM Cont Project Header View |
| SELECT W.BUSINESS_UNIT , W.CONTRACT_NUM , J.PROJECT_ID , P.GM_PRIMARY_FLAG , W.TITLE56 , D.DEPTID , D.INSTID , D.MAJOR_SUBDIVISION FROM PS_GM_AWARD W , PS_GM_AWD_PROJT_VW J , PS_PROJECT P , PS_GM_PRJ_DEPT D WHERE J.CONTRACT_NUM = W.CONTRACT_NUM AND P.BUSINESS_UNIT = J.BUSINESS_UNIT_PC AND P.PROJECT_ID = J.PROJECT_ID AND D.BUSINESS_UNIT = P.BUSINESS_UNIT AND D.PROJECT_ID = P.PROJECT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 3 | SUB_PROP_NBR |
Character(15) | VARCHAR2(15) NOT NULL | SUB_PROP_NBR |
| 4 | PRIMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Primary
N=No Y=Yes |
| 5 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 7 | INSTID | Character(5) | VARCHAR2(5) NOT NULL | Institution ID |
| 8 | MAJOR_SUBDIVISION | Character(10) | VARCHAR2(10) NOT NULL | Major Subdivision ID |