GM_MY_OP_TM_VW(SQL View) |
Index Back |
|---|---|
view for resource on demandView for Resource on Demand pagelet |
| SELECT DISTINCT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.PROJ_ROLE , A.QTY_X_HOURS , A.BEGIN_DT , A.END_DT , B.SUBMIT_STATUS , B.CONF_LEVEL FROM PS_GM_OPPTY_DTL_TM A , PS_GM_PROPOSAL B , PS_GM_MY_PROPOSAL D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROPOSAL_ID = B.PROPOSAL_ID AND A.VERSION_ID = B.VERSION_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROPOSAL_ID = D.PROPOSAL_ID AND B.PROPOSAL_FLG = 'S' AND B.CURRENT_VERSION = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROPOSAL_ID | Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 3 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 4 | QTY_X_HOURS | Number(11,0) | DECIMAL(11) NOT NULL | Quantity * Hours |
| 5 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | End Date |
| 7 | SUBMIT_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Proposal Submission Status
CMTD=03 - Committed CNCL=05 - Canceled DENY=04 - Denied DRAF=01 - Draft NSUB=Not Submitted RDY=02 - Ready SUBM=Submitted SUBR=Submitted With Error |
| 8 | CONF_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Confidence Level
H=01 - High L=O3 - Low M=02 - Medium |