HRS_HRAM_COUNT(SQL Table) |
Index Back |
|---|---|
HRS Counter recordCounter Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID_LAST | Number(15,0) | DECIMAL(15) NOT NULL | Last Person Id counter |
| 2 | HRS_PL_ID_LAST | Number(15,0) | DECIMAL(15) NOT NULL | Last resume number used |
| 3 | HRS_RES_NBR_LAST | Number(15,0) | DECIMAL(15) NOT NULL | Last resume number used |
| 4 | HRS_RES_ID_LAST | Number(15,0) | DECIMAL(15) NOT NULL | Last resume number used |
| 5 | HRS_CRSP_ID_LAST | Number(15,0) | DECIMAL(15) NOT NULL | correspondence id counter |
| 6 | HRS_APP_ACMP_ID | Number(15,0) | DECIMAL(15) NOT NULL | Accomplishment ID |
| 7 | HRS_APP_CMP_ID | Number(15,0) | DECIMAL(15) NOT NULL | Competency ID |
| 8 | HRS_RES_TMPL_ID | Number(15,0) | DECIMAL(15) NOT NULL | Resume Template ID |
| 9 | HRS_DUPE_PRCS_ID | Number(15,0) | DECIMAL(15) NOT NULL | Duplicate Process ID |