| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
HRS_VALUE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Integration Value ID
|
| 2 |
HRS_DM_MAP_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Assigned Mapping ID
|
| 3 |
HRS_CONTACT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Contact ID
|
| 4 |
HRS_AUTOSCREEN_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
AutoScreen ID
|
| 5 |
HRS_DM_VAL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Data Mapping Value ID.
|
| 6 |
HRS_DM_KEY_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Data Mapping Key ID
|
| 7 |
HRS_DM_CAT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Data Mapping Category ID
|
| 8 |
HRS_SOURCE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Source ID
|
| 9 |
HRS_AL_LOG_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Resume Extraction Queue ID
|
| 10 |
HRS_VNDR_TRANS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Id specific to a Vendor and Transaction
|
| 11 |
HRS_XSLT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
XSLT ID
|
| 12 |
HRS_TG_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Transaction Group ID
|
| 13 |
HRS_VENDOR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Integration Vendor ID
|
| 14 |
HRS_LOG_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Integration Log ID
|
| 15 |
HRS_SUBSOURCE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
SubSource ID
|
| 16 |
HRS_RESLOAD_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Resume Load ID
|
| 17 |
HRS_RESLOAD_RES_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Resume ID
|
| 18 |
HRS_EMAIL_SETUP_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Email Setup ID
|
| 19 |
HRS_AL_LOG_EXTR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Extractor Log ID
|
| 20 |
HRS_AL_LOG_NOTI_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Notification Log ID
|
| 21 |
HRS_AL_LOG_RES_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Resolution Log ID
|
| 22 |
HRS_EXT_POST_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
External Posting ID
|
| 23 |
HRS_XML_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
XML ID
|
| 24 |
HRS_PREMPL_PERS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Pre-Employment Person Id
|
| 25 |
HRS_AL_LOG_SRC_SEQ |
Number(15,0) |
DECIMAL(15) NOT NULL |
Unique Identifier - For Log Source
|