GEOG_LOCN_TBL(SQL Table) |
Index Back |
|---|---|
Geographic Locatn EligibilityGEOG_LOCN_TBL is a record that identifies ranges of Zip Codes or Canadian Postal Codes. It is used to define additional eligibility criteria for a medical benefit based on geographic location based on the employee's residence zip code. The record is updated online using the Geographic Location Eligibility table. It is used by the ENROLL Cobol program in the Benefits Administration product. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LOCATION_TBL_ID |
Character(4) | VARCHAR2(4) NOT NULL | Location Table ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | ELIG_FLG_GEO | Character(1) | VARCHAR2(1) NOT NULL |
Eligible or Ineligible
E=Eligible I=Ineligible Default Value: E |
| 7 | BAS_HOME_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Base Eligibility On
B=Both E=Either H=Home L=Location Default Value: E |
| 8 | GRP_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Group Method
1=Primary Job in Benefit Record 2=Flagged Jobs in Benefit Record 3=All Flagged Jobs Default Value: 1 |
| 9 | EVAL_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Evaluation Method
1=One or More in Group 2=All in Group 3=Sum Default Value: 1 Prompt Table: EVAL_METHOD_VW |
| 10 | EVAL_ACTV | Character(1) | VARCHAR2(1) NOT NULL |
Consider Active Jobs Only
Default Value: N |