HRS_APP_VSADT_I

(SQL View)
 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.

SELECT HRS_PERSON_ID ,COUNTRY ,HRS_VISA_PERMIT_TP ,VISA_WRKPMT_NBR ,VISA_WRKPMT_STATUS ,STATUS_DT ,DT_ISSUED ,PLACE_ISSUED ,DURATION_TIME ,DURATION_TYPE ,START_DT ,EXPIRATN_DT ,ISSUING_AUTHORITY , %subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_APP_VSA_DAT A

  • Related Language Record: HRS_APP_VPM_LNG

  • Parent record: HRS_APPLICANT

    • # 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 HRS_VISA_PERMIT_TP Character(3) VARCHAR2(3) NOT NULL Visa permit type
    4 VISA_WRKPMT_NBR Character(15) VARCHAR2(15) NOT NULL Visa/Permit Number
    5 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

    6 STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: %date

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

    Default Value: M

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