GM_BI_CSHR_VW(SQL View) |
Index Back |
|---|---|
Grants Billing Cost Sharing VWThe view links Billing back to Proj_Resource withOUT the use of Resource ID. |
| SELECT DISTINCT C.PROCESS_INSTANCE ,C.SEQ_NUM ,C.BUSINESS_UNIT ,C.INVOICE ,A.BUSINESS_UNIT ,C.CONTRACT_NUM ,C.BILL_STATUS ,A.PROJECT_ID ,A.ANALYSIS_TYPE ,A.ACCOUNT ,A.ACCOUNTING_DT ,A.RESOURCE_AMOUNT ,A.RESOURCE_ID FROM PS_PROJ_RESOURCE A ,PS_CA_DETAIL_PROJ B ,PS_BI_EXTRCT C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT_PC AND A.PROJECT_ID = B.PROJECT_ID AND B.CONTRACT_NUM = C.CONTRACT_NUM AND A.ANALYSIS_TYPE IN ( SELECT PAG.ANALYSIS_TYPE FROM PS_PROJ_AN_GRP_MAP PAG WHERE PAG.ANALYSIS_GROUP = 'CSTSH' AND PAG.SETID = ( SELECT SCR.SETID FROM PS_SET_CNTRL_REC SCR WHERE SCR.SETCNTRLVALUE = A.BUSINESS_UNIT AND SCR.RECNAME = 'PROJ_AN_GRP_MAP') ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 4 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 5 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 6 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 7 | BILL_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Bill Status
CAN=Canceled FNL=Finalized Bill HLD=Hold Bill INV=Invoiced Bill NEW=New Bill PND=Pending Approval RDY=Ready to Invoice TMP=Temporary Bill TMR=Temporary Ready Bill |
| 8 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 9 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 10 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 11 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 12 | RESOURCE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 13 | RESOURCE_ID | Character(40) | VARCHAR2(40) NOT NULL | Transaction ID |