GM_PROP_PROJ_VW(SQL View) |
Index Back |
|---|---|
Proposal Project View |
| SELECT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , A.SUB_PROP_NBR , A.PROJECT_ID , A.TITLE56 , A.PRIMARY_FLAG , A.INSTID , A.DEPTID , A.MAJOR_SUBDIVISION , A.CONTACT_ID , A.EMPLID , A.ROW_NUMBER , A.DESCR254 , A.PPSL_TO_PRJCT_FLG , A.BUSINESS_UNIT_PC , A.PROJECT_TYPE , A.PROJECT_MANAGER , A.STD_HOURS_DAY , A.HOLIDAY_LIST_ID FROM PS_GM_PROP_PROJ A |
| # | 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 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Proposal ID
Prompt Table: GM_PROP_ID_VW |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL |
Version ID
Prompt Table: GM_PROPOSAL |
| 4 | SUB_PROP_NBR |
Character(15) | VARCHAR2(15) NOT NULL | SUB_PROP_NBR |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 6 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |
| 7 | PRIMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Primary
N=No Y=Yes Y/N Table Edit Default Value: N |
| 8 | INSTID | Character(5) | VARCHAR2(5) NOT NULL |
Institution ID
Prompt Table: GM_INSTITUTION |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: GM_DEPT_TBL_VW |
| 10 | MAJOR_SUBDIVISION | Character(10) | VARCHAR2(10) NOT NULL |
Major Subdivision ID
Prompt Table: GM_DEPT_TBL_VW |
| 11 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: GM_PROP_DEPTJVW |
| 12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GM_ELIG_PI_VW |
| 13 | ROW_NUMBER | Number(3,0) | SMALLINT NOT NULL |
Row_Number
Default Value: 1 |
| 14 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 15 | PPSL_TO_PRJCT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Proposal Project To Project
D=Project Created N=Project Not Created P=Pre-Spending Y=Yes |
| 16 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 17 | PROJECT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Project Type
A=Activity G=Grant H=Phase P=Project S=Segment |
| 18 | PROJECT_MANAGER | Character(11) | VARCHAR2(11) NOT NULL | Project Manager |
| 19 | STD_HOURS_DAY | Number(5,2) | DECIMAL(4,2) NOT NULL | Standard Hours Day |
| 20 | HOLIDAY_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL | This is used to identify what holiday calendar to use. This is the access field for all financials groups. |