PC_SR_REVIEW_VW(SQL View) |
Index Back |
|---|
| SELECT EMPLID , BUSINESS_UNIT , PROJECT_ID , SR_START_DATE , SR_END_DATE , ACTIVITY_ID , PROJ_ROLE , NAME , DESCR , COMMENTS_2000 FROM PS_PC_SR_SUM_DTL WHERE SR_COMPLETE_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: PC_SR_BU_REW_VW |
| 3 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: OPR_DEF_TBL_PC.PROJECT_ID Prompt Table: PC_SR_PRJRW_VW |
| 4 | SR_START_DATE |
Date(10) | DATE |
Status Report start date
Prompt Table: PC_SR_STRTDT_VW |
| 5 | SR_END_DATE |
Date(10) | DATE | Status Report end date |
| 6 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PC_SR_ACTIV_VW |
| 7 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table: PC_SR_PJROLE_VW |
| 8 | NAME | Character(50) | VARCHAR2(50) NOT NULL |
Name
Prompt Table: PERSONAL_DATA |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | COMMENTS_2000 | Long Character | CLOB | Comment Text |