HRS_ERP_ELG_AET(SQL Table) |
Index Back |
|---|---|
ER_ERP_ELIG State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | REFERRAL_PGM_ID | Character(12) | VARCHAR2(12) NOT NULL | Employee referral program ID |
| 3 | REF_PGM_EFFDT | Date(10) | DATE | Referral Program Effective Dt |
| 4 | REF_EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Effective Status |
| 5 | DURATION | Number(5,0) | INTEGER NOT NULL | Recurrence Duration |
| 6 | DURATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Duration
D=Days M=Months Y=Years |
| 7 | DISQUALIFY | Character(1) | VARCHAR2(1) NOT NULL | Disqualify if Appl Rpts to EE |
| 8 | MANAGER_LEVEL | Character(2) | VARCHAR2(2) NOT NULL |
Manager Level
0=Chief Operating Officer 1=Director 2=Senior Officer 3=Vice President 4=Senior Manager 5=Mid-Level Manager 6=First-Line Manager 7=Supervisor 8=All Other Positions 9=Non-Manager |
| 9 | ALLOW_PREVIOUS | Character(1) | VARCHAR2(1) NOT NULL | Allow Previous Employees |
| 10 | DURATION_AWAY | Number(5,0) | INTEGER NOT NULL | Prior to Last Date Worked |
| 11 | DURATION_AWAY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Duration
D=Days M=Months Y=Years |
| 12 | CRT_DT_TYPE_ER | Character(1) | VARCHAR2(1) NOT NULL |
Prior To
H=Applicant's Hire Date R=Referral Date |
| 13 | ALLOW_FAMILY | Character(1) | VARCHAR2(1) NOT NULL | Allow Family Member Referrals |
| 14 | REQUIRE_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL | Require Approval for Payment |
| 15 | SEPCHK_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Separate check flag. |
| 16 | REF_RULE_ID | Character(12) | VARCHAR2(12) NOT NULL | Referral Date Rule ID |
| 17 | HIRE_RULE_ID | Character(12) | VARCHAR2(12) NOT NULL | Hire Date Rule ID |
| 18 | AWARD_RULE_ID | Character(12) | VARCHAR2(12) NOT NULL | Award Date Rule ID |
| 19 | CURR_RULE_ID | Character(12) | VARCHAR2(12) NOT NULL | Current Rule ID |
| 20 | DATE1 | Date(10) | DATE | Date 1 |
| 21 | DATE2 | Date(10) | DATE | Date 2 |
| 22 | EVENT_TYPE_ER | Character(1) | VARCHAR2(1) NOT NULL |
Recruiting Event Type
A=Award Eligibility Rule G=General Eligibility Criteria H=Hire Eligibility Rule M=Manual Override R=Referral Eligibility Rule |
| 23 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 24 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
| 25 | WHERE_CLS_ER | Long Character(4096) | CLOB | Where Clause for Rules and Hot Jobs |
| 26 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 27 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 28 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 29 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |