BUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
PROJECT_IDACTIVITY_IDPrompt Table: CURRENCY_CD_TBL
A=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason
1=Rate Set
2=Rate Plan
Default Value: 1
PC_PRQ_CPYAC_VW(SQL View) |
Index Back |
|---|---|
Activity View for Copy |
| SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,A.DESCR ,A.START_DT ,A.END_DT ,A.ACTIVITY_USER1 ,A.ACTIVITY_USER2 ,A.ACTIVITY_USER3 ,A.ACTIVITY_USER4 ,A.ACTIVITY_USER5 ,A.PC_ACT_USER_DT1 ,A.PC_ACT_USER_DT2 ,A.PC_USER_CURRENCY ,A.PC_ACT_USERAMT1 ,A.PC_ACT_USERAMT2 ,A.PC_ACT_USERAMT3 ,L.LOCATION ,A.ACTIVITY_TYPE ,B.RATE_SELECT ,B.PC_TEMPLATE_ID ,B.RATE_PLAN FROM PS_PROJ_ACTIVITY A LEFT OUTER JOIN PS_PROJ_ACT_LOC L ON %Join(COMMON_KEYS, PROJ_ACTIVITY A, PROJ_ACT_LOC L) LEFT OUTER JOIN PS_PC_PRICE_RATES B ON %Join(COMMON_KEYS, PROJ_ACTIVITY A, PC_PRICE_RATES B) WHERE (L.EFFDT IS NULL OR %EffdtCheck(PROJ_ACT_LOC L1, L, %CURRENTDATEIN)) AND (B.EFFDT IS NULL OR %EffdtCheck(PC_PRICE_RATES B1, B, %CURRENTDATEIN)) AND A.EFF_STATUS = '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 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | End Date |
| 7 | ACTIVITY_USER1 | Character(10) | VARCHAR2(10) NOT NULL | User 1 |
| 8 | ACTIVITY_USER2 | Character(10) | VARCHAR2(10) NOT NULL | User 2 |
| 9 | ACTIVITY_USER3 | Character(10) | VARCHAR2(10) NOT NULL | User 3 |
| 10 | ACTIVITY_USER4 | Character(10) | VARCHAR2(10) NOT NULL | User 4 |
| 11 | ACTIVITY_USER5 | Character(10) | VARCHAR2(10) NOT NULL | User 5 |
| 12 | PC_ACT_USER_DT1 | Date(10) | DATE | Date 1 |
| 13 | PC_ACT_USER_DT2 | Date(10) | DATE | Date 2 |
| 14 | PC_USER_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
User Currency
Prompt Table: CURRENCY_CD_TBL |
| 15 | PC_ACT_USERAMT1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 1 |
| 16 | PC_ACT_USERAMT2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 2 |
| 17 | PC_ACT_USERAMT3 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 3 |
| 18 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 19 | ACTIVITY_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason |
| 20 | RATE_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
This will determine selection of 1) Rate Set and 2) Rate Plan in Project Type, Project and Activity.
1=Rate Set 2=Rate Plan Default Value: 1 |
| 21 | PC_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL | Rate Template ID |
| 22 | RATE_PLAN | Character(15) | VARCHAR2(15) NOT NULL | Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line. |