HRS_JOB_AGN_STG(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CHUNKSIZE |
Number(10,0) | DECIMAL(10) NOT NULL | Chunk Size |
| 3 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 4 | SEARCH_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Stored Search Name |
| 5 | APP_PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the type of applicant - External Applicant, Employee or Non-Employee
A=External Applicant E=Employee N=Non-Employee |
| 6 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 7 | LAST_UPDATE_DATE | Date(10) | DATE | Date of last update |
| 8 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 9 | HRS_POSTED_WTN | Character(1) | VARCHAR2(1) NOT NULL |
Time period
A=Anytime M=Last Month Q=Last Three Months W=Last Week Y=Last Year |
| 10 | SAL_RANGE_MIN_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Salary Range Minimum Rate |
| 11 | SAL_RANGE_MAX_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Salary Range Maximum Rate |
| 12 | SAL_RANGE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Salary Range Currency |
| 13 | SAL_RANGE_FREQ | Character(5) | VARCHAR2(5) NOT NULL | Salary Range Frequency |
| 14 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |
| 15 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time |
| 16 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 17 | HRS_RECR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Recruiter |
| 18 | HRS_MGR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Hiring Manager |
| 19 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Site ID |
| 20 | LANG_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese |
| 21 | HRS_JOBAGENT_IND | Character(1) | VARCHAR2(1) NOT NULL | Job Agent Indicator |
| 22 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |