PROCESS_INSTANCEA=Asset
L=Labor
M=Material
O=Other
E=Employee
G=Generic Resource
N=Not Applicable
UPG_PGM_AET(SQL Table) |
Index Back |
|---|---|
PGM Upgrade State RecordThis is the state record used for Program Management Upgrade application engines. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | END_DT | Date(10) | DATE | End Date |
| 4 | HOLIDAY_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL | This is used to identify what holiday calendar to use. This is the access field for all financials groups. |
| 5 | PC_DURATION_DAYS | Number(8,0) | INTEGER NOT NULL | Duration in Days |
| 6 | PC_HOURS_PER_DAY | Number(2,0) | SMALLINT NOT NULL | Hours per Day |
| 7 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 8 | SCHED_NUM | Number(5,0) | INTEGER NOT NULL | Team sequence number |
| 9 | START_DT | Date(10) | DATE | Start Date |
| 10 | TEAM_MEMBER | Character(30) | VARCHAR2(30) NOT NULL | Team Member |
| 11 | TEAM_MEMBER_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
05/26/2004 - FS
Translate Value "O" added.
A=Asset L=Labor M=Material O=Other |
| 12 | TEAM_MEMBER_IND | Character(1) | VARCHAR2(1) NOT NULL |
Team Member Indicator
E=Employee G=Generic Resource N=Not Applicable |
| 13 | WORK_CNT | Number(10,0) | DECIMAL(10) NOT NULL | Count of Anything |