PROCESS_INSTANCECRR=Change Request Required
CRR=Change Request Required
OFF=Off
ON=On
PC_EX_TO_PC_AET(SQL Table) |
Index Back |
|---|---|
PC_EX_TO_PC State RecState record used in PC_EX_TO_PC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | CHANGE_REQ_ID | Character(15) | VARCHAR2(15) NOT NULL | Change Request ID |
| 5 | PC_CHC_COUNT | Number(15,0) | DECIMAL(15) NOT NULL | Count of Changes |
| 6 | PC_CHC_UPD_ETC | Character(3) | VARCHAR2(3) NOT NULL |
change control template for a resource's estimate to complete for a given activity
CRR=Change Request Required CRR=Change Request Required OFF=Off ON=On |
| 7 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 8 | PROJECT_ID_2 | Character(15) | VARCHAR2(15) NOT NULL | Project |
| 9 | PREV_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Previous Business Unit |
| 10 | REMAINING_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | New Remaining work in hours |
| 11 | RESOURCE_ETC | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Estimate to Complete |
| 12 | TEAM_MEMBER | Character(30) | VARCHAR2(30) NOT NULL | Team Member |
| 13 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |