MARKETMODEL_MARKET_VW(SQL View) |
Index Back |
|---|---|
Market CodesThis view fetches all market codes defined in the system. There are only 4 values that are of interest to Paycheck Modeling in order to provide context to the Text to be requested from Text Catalog. They are: USA, CAN, USF and GBL. |
| SELECT %Substring(A.FIELDVALUE, 1, 3) , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME='MARKET' 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 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |