BUSINESS_UNITPROJECT_IDACTIVITY_IDAL=Allocated
CA=Cancelled
CM=Committed
CO=Considered
CP=Completed
RE=Rejected
RQ=Requested
A=Assign
C=Complete
I=Interview
P=Propose
R=Reject
S=Reserve
V=Pending Approval
X=Cancel
Prompt Table: RS_ASSGN_ST_TBL
RS_FUTASSN_TMP(SQL Table) |
Index Back |
|---|---|
Future projects/activitiesTemp table for HGRID of the future projects/activities in Transfer Assignment component. It contains the grid data. This table will never be saved to DBMS. |
| # | 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 | PROJ_ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Project or activity ID used for the grids for transfering assignments. It can be PROJECT_ID or project ACTIVITY_ID. |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | RESOURCE_STS | Character(2) | VARCHAR2(2) NOT NULL |
11/15/2004 - New field added.
AL=Allocated CA=Cancelled CM=Committed CO=Considered CP=Completed RE=Rejected RQ=Requested |
| 7 | ASSIGN_STS | Character(2) | VARCHAR2(2) NOT NULL |
Assignment Status
A=Assign C=Complete I=Interview P=Propose R=Reject S=Reserve V=Pending Approval X=Cancel Prompt Table: RS_ASSGN_ST_TBL |
| 8 | STATUS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Status Description |
| 9 | START_DT | Date(10) | DATE | Start Date |
| 10 | END_DT | Date(10) | DATE | End Date |
| 11 | DURATION_DAYS_STR | Character(8) | VARCHAR2(8) NOT NULL | Duration days in string |
| 12 | ASSGND_WORK_STR | Character(16) | VARCHAR2(16) NOT NULL | Assignment work in hours and in string |
| 13 | REMAINING_WORK_STR | Character(16) | VARCHAR2(16) NOT NULL | Remaining work in hours and in string |
| 14 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |