LOCALITYEFFDTDefault Value: %date
Prompt Table: STATE_TAX_TBL
TRW_LOCALITY_VW(SQL View) |
Index Back |
|---|---|
TRW Locality Table ViewThis view is used to retrieve Locality code for a Reward Item Filter. |
| SELECT LOCALITY , EFFDT , STATE , LOCALITY_NAME FROM PS_LOCAL_TAX_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LOCALITY |
Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TAX_TBL |
| 4 | LOCALITY_NAME | Character(40) | VARCHAR2(40) NOT NULL | Locality Name |