PC_PRQ_PROJ_ACT(SQL Table) |
Index Back |
|---|---|
Activity Request Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PC_REQUEST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Request Id |
| 2 | PC_REQUEST_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Request Type |
| 3 | PC_REQUEST_DESCR |
Character(254) | VARCHAR2(254) NOT NULL | Request Description |
| 4 | PC_REQ_ACTIVITY |
Number(15,0) | DECIMAL(15) NOT NULL | Activity Id |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 7 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 8 | ACTIVITY_ID_2 | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PC_PRQ_ACTDYVW |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | START_DT | Date(10) | DATE | Start Date |
| 11 | END_DT | Date(10) | DATE | End Date |
| 12 | PROJECT_MANAGER | Character(11) | VARCHAR2(11) NOT NULL | Project Manager |
| 13 | PC_REQUESTOR | Character(30) | VARCHAR2(30) NOT NULL | Requester |
| 14 | BUDGETED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Budgeted Assets |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | PC_REQUEST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Request Status
A=Approved B=Pushback D=Denied I=In Progress P=Pending |
| 17 | ACTIVITY_USER1 | Character(10) | VARCHAR2(10) NOT NULL | User 1 |
| 18 | ACTIVITY_USER2 | Character(10) | VARCHAR2(10) NOT NULL | User 2 |
| 19 | ACTIVITY_USER3 | Character(10) | VARCHAR2(10) NOT NULL | User 3 |
| 20 | ACTIVITY_USER4 | Character(10) | VARCHAR2(10) NOT NULL | User 4 |
| 21 | ACTIVITY_USER5 | Character(10) | VARCHAR2(10) NOT NULL | User 5 |
| 22 | PC_ACT_USER_DT1 | Date(10) | DATE | Date 1 |
| 23 | PC_ACT_USER_DT2 | Date(10) | DATE | Date 2 |
| 24 | PC_USER_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
User Currency
Prompt Table: CURRENCY_CD_TBL |
| 25 | PC_ACT_USERAMT1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 1 |
| 26 | PC_ACT_USERAMT2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 2 |
| 27 | PC_ACT_USERAMT3 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 3 |
| 28 | EFFDT | Date(10) | DATE | Effective Date |
| 29 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 30 | 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 Prompt Table:
PC_WC_ACTTYP_VW
|
| 31 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 32 | 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 |
| 33 | PC_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL |
Rate Template ID
Prompt Table: PC_PRQ_RATE_VW2 |
| 34 | 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.
Prompt Table: PC_PRQ_RTPL_VW |