EP_TP_SUB_STATUS1=1
10=10
11=11
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
F=F
EP_TPSUBSTAT_VW(SQL View) |
Index Back |
|---|---|
Track Progress Sub statusview of Track Progress sub status Translate Values |
| SELECT %Substring(A.FIELDVALUE, 1, 2) , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME='EP_TP_SUB_STATUS' AND A.EFFDT= ( SELECT MAX(X.EFFDT) FROM PSXLATITEM X WHERE X.FIELDNAME=A.FIELDNAME AND X.FIELDVALUE=A.FIELDVALUE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_TP_SUB_STATUS |
Character(2) | VARCHAR2(2) NOT NULL |
Sub Status for the Track Progress step in the process.
The value will be 1-11 or 99 for Finalize.
1=1 10=10 11=11 2=2 3=3 4=4 5=5 6=6 7=7 8=8 9=9 F=F |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |