PC_RW_TM_MBR_VW(SQL View) |
Index Back |
|---|
| SELECT ' ' ,' ' ,' ' ,' ' ,%DateNull ,%DateNull ,0 ,' ' ,' ' ,0 ,0 ,0 ,0 FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 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 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |
| 8 | RES_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Resource Status. This field is used in the Resource Workbench page for the Resource Status Selection Criteria.
A=All CM=Committed CP=Completed RQ=Requested |
| 9 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 10 | AVAIL_UNITS | Number(6,0) | INTEGER NOT NULL | Availability Units |
| 11 | ASSGND_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Assigned Work |
| 12 | ACTUAL_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Actual Work |
| 13 | REMAINING_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | New Remaining work in hours |