PROJECT_IDPrompt Table: PROJECT
BEGIN_DTSCHEDULE_TYPEPrompt Table: PROJ_PHASE_TBL
SCHEDULE_STATUSA=Actual Schedule
E=Estimated Schedule
PROJ_SCHED_VW(SQL View) |
Index Back |
|---|---|
Project Schedule View |
| SELECT PROJECT_ID ,FROM_DT ,SCHEDULE_TYPE ,SCHEDULE_STATUS ,DESCR ,TO_DT FROM PS_PROJECT_SCHED |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT |
| 2 | BEGIN_DT |
Date(10) | DATE | Begin Date |
| 3 | SCHEDULE_TYPE |
Character(15) | VARCHAR2(15) NOT NULL |
Phase Type
Prompt Table: PROJ_PHASE_TBL |
| 4 | SCHEDULE_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Schedule Status
A=Actual Schedule E=Estimated Schedule |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | END_DT | Date(10) | DATE | End Date |