HRS_HROI_COUNT(SQL Table) |
Index Back |
---|---|
Unique ID Counter TableCounter Table |
# | 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_DM_VAL_ID | Number(15,0) | DECIMAL(15) NOT NULL | Data Mapping Value ID. |
4 | HRS_DM_KEY_ID | Number(15,0) | DECIMAL(15) NOT NULL | Data Mapping Key ID |
5 | HRS_DM_CAT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Data Mapping Category ID |
6 | HRS_VNDR_TRANS_ID | Number(15,0) | DECIMAL(15) NOT NULL | Id specific to a Vendor and Transaction |
7 | HRS_XSLT_ID | Number(15,0) | DECIMAL(15) NOT NULL | XSLT ID |
8 | HRS_TG_ID | Number(15,0) | DECIMAL(15) NOT NULL | Transaction Group ID |
9 | HRS_VENDOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Integration Vendor ID |
10 | HRS_LOG_ID | Number(15,0) | DECIMAL(15) NOT NULL | Integration Log ID |
11 | HRS_XML_ID | Number(15,0) | DECIMAL(15) NOT NULL | XML ID |
12 | HRS_LAST_CAL_UID | Number(15,0) | DECIMAL(15) NOT NULL |
Last Calendar UID
Default Value: 1000 |