GM_PM_OPPTY_VW(SQL View) |
Index Back |
|---|---|
PM Resource Line Detail View |
| SELECT A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , A.SUB_PROP_NBR , A.BUDGET_ID , A.BUDGET_PERIOD_GM , A.BUDGET_LN , A.SEQ_NUM , B.BEGIN_DT , B.END_DT , E.NAME1 , A.DESCR , A.TEAM_MEMBER_CLASS , SUM(A.QTY_INTEGER) , SUM(A.BILL_AMT) , C.SCEN_ADJUST_PCT_TM , C.PROPOSAL_TITLE , C.TITLE56 , C.CUST_ID , P.TITLE56 , F.DESCR , SUM(A.COST_AMT) , A.PM_MARGIN_PCT , A.PROJ_ROLE , A.TEAM_MEMBER FROM PS_GM_OPPTY_DTL_TM A , PS_GM_BUD_PERIOD B , PS_GM_PROP_PROJ P , PS_GM_PROPOSAL C , PS_CUSTOMER E , PS_SET_CNTRL_REC ES , PS_BUS_UNIT_TBL_FS F WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PROPOSAL_ID = A.PROPOSAL_ID AND B.VERSION_ID = A.VERSION_ID AND B.SUB_PROP_NBR = A.SUB_PROP_NBR AND B.BUDGET_ID = A.BUDGET_ID AND B.BUDGET_PERIOD_GM = A.BUDGET_PERIOD_GM AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.PROPOSAL_ID = B.PROPOSAL_ID AND C.VERSION_ID = B.VERSION_ID AND C.PROPOSAL_FLG = 'S' AND ES.SETCNTRLVALUE = A.BUSINESS_UNIT AND ES.RECNAME = 'CUSTOMER' AND E.SETID = ES.SETID AND E.CUST_ID = C.CUST_ID AND P.BUSINESS_UNIT = A.BUSINESS_UNIT AND P.PROPOSAL_ID = A.PROPOSAL_ID AND P.VERSION_ID = A.VERSION_ID AND P.SUB_PROP_NBR = A.SUB_PROP_NBR AND F.BUSINESS_UNIT = A.BUSINESS_UNIT GROUP BY A.BUSINESS_UNIT , A.PROPOSAL_ID , A.VERSION_ID , A.SUB_PROP_NBR , A.BUDGET_ID , A.BUDGET_PERIOD_GM , A.BUDGET_LN , A.SEQ_NUM , B.BEGIN_DT , B.END_DT , E.NAME1 , A.DESCR , A.TEAM_MEMBER_CLASS , C.SCEN_ADJUST_PCT_TM , C.PROPOSAL_TITLE , C.TITLE56 , C.CUST_ID , P.TITLE56 , F.DESCR , A.PM_MARGIN_PCT, A.PROJ_ROLE , A.TEAM_MEMBER |
| # | 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 | VERSION_ID | Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 4 | SUB_PROP_NBR | Character(15) | VARCHAR2(15) NOT NULL | SUB_PROP_NBR |
| 5 | BUDGET_ID | Character(15) | VARCHAR2(15) NOT NULL | BUDGET_ID |
| 6 | BUDGET_PERIOD_GM | Number(3,0) | SMALLINT NOT NULL | BUDGET_PERIOD_GM |
| 7 | BUDGET_LN | Number(6,0) | INTEGER NOT NULL | BUDGET_LN |
| 8 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 9 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 10 | END_DT | Date(10) | DATE | End Date |
| 11 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | TEAM_MEMBER_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
05/26/2004 - FS
Translate Value "O" added.
A=Asset L=Labor M=Material O=Other |
| 14 | QTY_INTEGER | Number(11,0) | DECIMAL(11) NOT NULL | Quantity Rounded to 0 Decimals |
| 15 | BILL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
| 16 | SCEN_ADJUST_PCT_TM | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Scenario Adjustment % for Time 06/09/2004 PR_FS_B005 Added Label - LABOR_ADJUST |
| 17 | PROPOSAL_TITLE | Character(56) | VARCHAR2(56) NOT NULL | Description |
| 18 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |
| 19 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 20 | TITLE_GR | Character(56) | VARCHAR2(56) NOT NULL | Title |
| 21 | DESCR_2 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 22 | COST_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Amount |
| 23 | PM_MARGIN_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Margin Percent |
| 24 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 25 | TEAM_MEMBER | Character(30) | VARCHAR2(30) NOT NULL | Team Member |