GUARANTOR_TBL

(SQL Table)
Index Back

Guarantor Table

Record used to define Guarantor information and processing options, by Aid Year.

  • Related Language Record: GUARANTOR_LANG
  • Parent Record Of GUARNTR_CONTACT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GUAR_UNQ_ID Number(3,0) SMALLINT NOT NULL Guarantor ID
    2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    3 GUAR_OE_CD Character(3) VARCHAR2(3) NOT NULL Guarantor OE Code

    Prompt Table: GUAR_LOAD_TBL

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: GUAR_LOAD_TBL.DESCR

    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: GUARANTOR_TBL.DESCRSHORT

    6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    11 CITY Character(30) VARCHAR2(30) NOT NULL City
    12 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    13 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    14 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    15 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    16 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    17 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    18 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    19 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    21 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    22 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    23 MAILBOX_ID Character(40) VARCHAR2(40) NOT NULL Mailbox ID

    Default Value: GUAR_LOAD_TBL.MAILBOX_ID

    24 MAILBOX_TYPE Character(4) VARCHAR2(4) NOT NULL Mailbox Type
    C=Compuserve
    I=Internet

    Default Value: GUAR_LOAD_TBL.MAILBOX_TYPE

    25 ELECTRONIC_LINK Character(1) VARCHAR2(1) NOT NULL Electronic Link

    Y/N Table Edit

    Default Value: Y

    26 DUNS_ID Character(9) VARCHAR2(9) NOT NULL DUNS ID