SPA_PL_SRCH_VW(SQL View) |
Index Back |
|---|---|
Progress Log Add ViewProgress Log Add View |
| SELECT DISTINCT a.plog_id , a.person_id , a.vendor_id , a.plog_status , a.template_id FROM ps_spa_plog_hdr a , PS_SPB_SERVICE_PRV b WHERE a.person_id = b.person_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PLOG_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
Default Value: SPA_PLOG_HDR.PLOG_ID |
| 2 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: SPA_PLOG_HDR.VENDOR_ID |
| 4 | PLOG_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Progress Log Status
ADJ=Adjusted APR=Approved DEN=Denied HLD=Hold LDN=Line Denied LPD=Line Pending OPN=Open PND=Pending SUB=Submitted Default Value: SPA_PLOG_HDR.PLOG_STATUS |
| 5 | TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL |
Project Template
Default Value: SPA_PLOG_HDR.TEMPLATE_ID |