GEOG_LOCN_RANGE

(SQL Table)
Index Back

Geographic Locatn Elig Range

GEOG_LOCN_RANGE is a child record of the PS_GEOG_LOCN_TBL record. For every Location_Tbl_Id a zip code range is specified. The record is updated online using the Geographic Location Eligibility table. It is used by the ENROLL Cobol program in the Benefits Administration product.

  • Parent record: GEOG_LOCN_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LOCATION_TBL_ID Character(4) VARCHAR2(4) NOT NULL Location Table ID

    Prompt Table: GEOG_LOCN_TBL

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 LOCN_FROM Character(12) VARCHAR2(12) NOT NULL Beginning of Range
    4 LOCN_TO Character(12) VARCHAR2(12) NOT NULL End of Range

    Default Value: GEOG_LOCN_RANGE.LOCN_FROM