CC_STATUS0=Staged
1=Initial
2=Verified
3=Approved
4=Closed
5=Error
6=Processing
Y/N Table Edit
CC_CC_STATUS_VW(SQL View) |
Index Back |
|---|---|
ProCard PO Status View |
| SELECT %Substring(A.FIELDVALUE, 1, 1) , 'N' FROM PSXLATITEM A WHERE A.FIELDNAME = 'CC_STATUS' AND FIELDVALUE <> '4' AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PSXLATITEM AA WHERE AA.FIELDNAME = A.FIELDNAME AND AA.FIELDVALUE = A.FIELDVALUE AND AA.EFF_STATUS = 'A' AND AA.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CC_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Statement Status
0=Staged 1=Initial 2=Verified 3=Approved 4=Closed 5=Error 6=Processing |
| 2 | SEL | Character(1) | VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit |