CS_DOC_STATUSAA=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
CS_DOC_STAT_VW(SQL View) |
Index Back |
|---|---|
Doc Status Xlat VW |
| SELECT %Substring(B.FIELDVALUE ,1 ,2) , B.XLATLONGNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'CS_DOC_STATUS' AND %EffdtCheck(PSXLATITEM A, B, %CURRENTDATEIN) AND B.EFF_STATUS = 'A' |
| # | 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 | CS_CLSTYP_DESC | Character(30) | VARCHAR2(30) NOT NULL | Clause Type |