SR_SUM_DTL_IP(SQL Table) |
Index Back |
---|---|
Status Report Summary DetailStatus Report Summary Detail |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
3 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
4 | SR_START_DATE | Date(10) | DATE NOT NULL | Status Report start date |
5 | SR_END_DATE | Date(10) | DATE | Status Report end date |
6 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
7 | IP_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Interested Parties EmplID |
8 | NAME | Character(50) | VARCHAR2(50) NOT NULL |
Name
Prompt Table: NAMES |
9 | IP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Interested Parties Names |