HRS_VSA_DAT_HST

(SQL Table)
 Index Back

Applicant Visa/Permits

Use APP_ VSA_PMT_DTA to record visas and permits held by an applicant. Use a subordinate record,APP_VSA_PMT_SUPPRT, to identify documents presented in support of each visa or permit.

  • Parent record: HRS_APPLICANT

    • # 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 HRS_VISA_PERMIT_TP Character(3) VARCHAR2(3) NOT NULL Visa permit type
    6 VISA_WRKPMT_NBR Character(15) VARCHAR2(15) NOT NULL Visa/Permit Number
    7 VISA_WRKPMT_STATUS Character(1) VARCHAR2(1) NOT NULL Visa/Permit Status
    A=Applied For
    C=Cancelled
    G=Granted
    N=Renewed
    R=Renewal in Progress

    Default Value: A

    8 STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: %date

    9 DT_ISSUED Date(10) DATE Issue Date
    10 PLACE_ISSUED Character(30) VARCHAR2(30) NOT NULL Place of Issue
    11 DURATION_TIME Number(6,1) DECIMAL(5,1) NOT NULL Duration Time
    12 DURATION_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Duration
    D=Days
    M=Months
    Y=Years

    Default Value: M

    13 START_DT Date(10) DATE Start Date
    14 EXPIRATN_DT Date(10) DATE Expiration Date
    15 ISSUING_AUTHORITY Character(50) VARCHAR2(50) NOT NULL Issuing Authority
    16 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    17 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    18 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    19 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id