HRS_DM_FKEYDefault Value: OPR_DEF_TBL_HR.COUNTRY
Prompt Table: COUNTRY_TBL
HRS_DM_STATE_VW(SQL View) |
Index Back |
|---|---|
State Codes/Names w/in CountrySTATE_NAMES_TBL is delivered pre-loaded with both character and numeric codes for U.S. states and Canadian provinces. The high-order key to the table is COUNTRY. The data in a similar table, STATE_NAMES_OTH, is identical to STATE_NAMES_TBL. The difference is STATE_NAMES_TBL is the edit table for the STATE field and STATE_NAMES_OTH is the edit table for the STATE_OTHER field. If you need a table with state/province names without COUNTRY, use STATE_NAMES_VW. |
| SELECT COUNTRY %Concat '_' %Concat STATE , STATE , DESCR , COUNTRY , COUNTRY , STATE FROM PS_HRS_STATE_I |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_DM_FKEY |
Character(30) | VARCHAR2(30) NOT NULL | Data Mapping Forigen Key. Used by Data mapping keys to store the key from the forigen table, for use when performing a sync operation. |
| 2 | HRS_DM_KEY_NAME | Character(50) | VARCHAR2(50) NOT NULL | Data Mapping Key Name. This is what is shown in value mappings. |
| 3 | HRS_DM_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Data Mapping Object Description |
| 4 | HRS_DM_SUBCAT | Character(50) | VARCHAR2(50) NOT NULL | SubCategory |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: OPR_DEF_TBL_HR.COUNTRY Prompt Table: COUNTRY_TBL |
| 6 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |