GM_PT_PRJ_CT_VW(SQL View) |
Index Back |
|---|---|
Project Certification View |
| SELECT A.BUSINESS_UNIT_PC , A.PROJECT_ID , A.CERT_CODE , A.COMPLNC_INDICATOR , A.CERT_DT , A.EXPIRE_DT , A.APPROVAL_DATE , A.EMPLID , A.ASSURANCE_NBR , A.EXEMPTION_NBR , A.FULL_REVIEW , A.EXPEDITED_REVIEW , A.COMMENTS FROM PS_GM_AWD_CERT A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
| 3 | CERT_CODE |
Character(5) | VARCHAR2(5) NOT NULL |
Certification Code
Prompt Table: GM_CERT_TBL_VW |
| 4 | COMPLNC_INDICATOR | Character(3) | VARCHAR2(3) NOT NULL |
Indicator
NA=Not Applicable NO=No PD=Pending Approval YS=Yes |
| 5 | CERT_DT | Date(10) | DATE |
Certification Date
Default Value: %date |
| 6 | EXPIRE_DT | Date(10) | DATE | Expiration Dt |
| 7 | APPROVAL_DATE | Date(10) | DATE |
Approval Date
Default Value: %date |
| 8 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GM_ELIG_PI2_VW |
| 9 | ASSURANCE_NBR | Character(20) | VARCHAR2(20) NOT NULL | Assurance Number |
| 10 | EXEMPTION_NBR | Character(20) | VARCHAR2(20) NOT NULL | Exemption Number |
| 11 | FULL_REVIEW | Character(1) | VARCHAR2(1) NOT NULL |
Full Review
Y/N Table Edit |
| 12 | EXPEDITED_REVIEW | Character(1) | VARCHAR2(1) NOT NULL |
Expedited Review
Y/N Table Edit |
| 13 | COMMENTS | Long Character | CLOB | Comment |