STATEPY_JUR_CODEPY_JUR_MW_VW1(SQL View) |
Index Back |
|---|---|
Jurisdiction prompt viewThis view is to make it a prompt table for Jurisdiction code usedin Minimum Wage |
| SELECT DISTINCT A.STATE ,A.PY_JUR_CODE ,A.PY_JUR_NAME FROM PS_PY_JUR_MW_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 2 | PY_JUR_CODE |
Character(10) | VARCHAR2(10) NOT NULL | This field is used for storing Jurisdiction Code for the state |
| 3 | PY_JUR_NAME | Character(30) | VARCHAR2(30) NOT NULL | This field is used for storing Jurisdiction Name per Jurisdiction Code for the state |