SCP_C_DOC_VW_FL(SQL View) |
Index Back |
|---|---|
Document Header View |
| SELECT CS_DOC_STATUS , 'Y' , COUNT(*) FROM PS_SCP_CNTRCTVW_FL WHERE CLOSE_FLAG = 'N' AND CS_DOC_STATUS = 'EC' GROUP BY CS_DOC_STATUS UNION SELECT CS_EXT_SIGN_STATUS , 'Y' , COUNT(*) FROM PS_SCP_CNTRCTVW_FL WHERE CLOSE_FLAG = 'N' AND CS_EXT_SIGN_STATUS = 'PS' GROUP BY CS_EXT_SIGN_STATUS UNION SELECT 'A' , 'Y' , COUNT(*) FROM PS_SCP_CNTRCTVW_FL WHERE CLOSE_FLAG = 'N' AND (CS_DOC_STATUS = 'EC' OR ( CS_EXT_SIGN_STATUS = 'PS')) UNION SELECT 'R' , 'Y' , 1 FROM PS_SCP_CNTRCTVW_FL WHERE 1=1 UNION SELECT 'U' , 'Y' , 1 FROM PS_SCP_CNTRCTVW_FL WHERE 1=1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Document Status
AA=Approved AD=Denied AP=Pending Approval CC=Collaborated CP=Pending Collaboration CR=Collaborated, Pending Review DC=Complete DR=Draft DS=Dispatched EC=Pending External Collaboration EX=Executed PI=Pending Internal Review |
| 2 | DEFAULTROLE | Character(1) | VARCHAR2(1) NOT NULL | Use default Role |
| 3 | COUNT1 | Number(10,0) | DECIMAL(10) NOT NULL | Counter |