HRS_APP_CZ_PSPT

(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_APP_CPS_LNG
  • Parent record: HRS_APP_CITSHIP
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Default Value: CITIZENSHIP.COUNTRY

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_NAMES_PSP

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