CNTRCT_STATUSA=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled
CS_CNT_STAT_VW(SQL View) |
Index Back |
|---|---|
Contract Status Xlat ViewView for contract status xlats. |
| SELECT %Substring(X.FIELDVALUE, 1, 1) , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'CNTRCT_STATUS' AND X.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CNTRCT_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Contract Status
A=Approved C=Closed H=On-Hold O=Open P=Pre-Approved X=Canceled |
| 2 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |