RS_ED_ASSIGNMNT(SQL View) |
Index Back |
|---|---|
ETL RM Assignments |
| SELECT A.EMPLID , A.BUSINESS_UNIT , A.PROJECT_ID , P.DESCR , '' , '' , '' , '' , '' , '' FROM PS_RS_ED_ETL_LOG L , PS_EID_ETL_LASTRUN R , PS_RS_ASSIGNMENT A , PS_RS_ASSGN_DETAIL B , PS_PROJECT P WHERE R.EID_DS_ID = 'Resources' AND L.DTTM_MODIFIED >= R.LAST_RUN_DTM AND L.DOCUMENT = A.EMPLID AND A.SYSTEM_SOURCE = 'RS' AND B.ASSIGNMENT_ID = A.ASSIGNMENT_ID AND (B.START_DT BETWEEN %CurrentDateIn AND %DateAdd(%CurrentDateIn,365) OR B.END_DT BETWEEN %CurrentDateIn AND %DateAdd(%CurrentDateIn,365)) AND P.BUSINESS_UNIT = A.BUSINESS_UNIT AND P.PROJECT_ID = A.PROJECT_ID GROUP BY A.EMPLID, A.BUSINESS_UNIT, A.PROJECT_ID, P.DESCR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: RS_WRKR_ADD_VW |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 3 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: %EDITTABLE5 |
| 4 | PROJ_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Project ID Description |
| 5 | PC_ACTUAL_HRS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Actual Hours |
| 6 | ACTUAL_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Actual Invoice Amount |
| 7 | BILLED_TO_DATE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billed To Date |
| 8 | BILL_RATE_ACT | Number(27,3) | DECIMAL(26,3) NOT NULL | Bill Rate in Activity team (ARL). |
| 9 | COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Rate |
| 10 | MARGIN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Margin |