HRS_APCZPT_HST

(SQL Table)
 Index Back

Applic/Dependent Passport Data

Use APP_CITIZN_PSPT to record passport data for an applicant. Country of citizenship is recorded on APP_CITIZENSHIP.

  • Related Language Record: HRS_APCPSLG_HST

  • Parent record: HRS_APP_CITSHIP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    5 PASSPORT_NBR Character(15) VARCHAR2(15) NOT NULL Passport Number
    6 DT_ISSUED Date(10) DATE Issue Date
    7 EXPIRATN_DT Date(10) DATE Expiration Date
    8 COUNTRY_PASSPORT Character(3) VARCHAR2(3) NOT NULL Country Issuing Passport

    Default Value: CITIZENSHIP.COUNTRY

    Prompt Table: COUNTRY_TBL

    9 STATE_PASSPORT Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NAMES_PSP

    10 CITY_PASSPORT Character(30) VARCHAR2(30) NOT NULL City
    11 ISSUING_AUTHORITY Character(50) VARCHAR2(50) NOT NULL Issuing Authority
    12 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    13 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    14 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    15 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    16 COMMENTS Long Character CLOB Comment