HRS_HIRE_VSA_DA

(SQL View)
 Index Back

Hire - Visa Permit Support

Hire Integration - Visa Permit Support

SELECT B.EMPLID ,A.HRS_PERSON_ID ,' ' ,%CurrentDateIn ,A.COUNTRY ,A.HRS_VISA_PERMIT_TP ,A.VISA_WRKPMT_NBR ,A.VISA_WRKPMT_STATUS ,A.STATUS_DT ,A.DT_ISSUED ,A.PLACE_ISSUED ,A.DURATION_TIME ,A.DURATION_TYPE ,A.START_DT ,A.EXPIRATN_DT ,A.ISSUING_AUTHORITY ,B.HRS_HIRE_SEQ FROM PS_HRS_APP_VSA_DAT A ,PS_HRS_HIRE B WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID

  • Related Language Record: HRS_HIREVSA_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    3 DEPENDENT_ID Character(2) VARCHAR2(2) NOT NULL Dependent ID
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %DATE

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

    Prompt Table: COUNTRY_TBL

    6 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type
    7 VISA_WRKPMT_NBR Character(15) VARCHAR2(15) NOT NULL Visa/Permit Number
    8 VISA_WRKPMT_STATUS Character(1) VARCHAR2(1) NOT NULL Visa/Permit Status
    A=Applied For
    C=Cancelled
    G=Granted
    N=Renewed
    R=Renewal
    9 STATUS_DT Date(10) DATE NOT NULL Status Date
    10 DT_ISSUED Date(10) DATE Issue Date
    11 PLACE_ISSUED Character(30) VARCHAR2(30) NOT NULL Place of Issue
    12 DURATION_TIME Number(6,1) DECIMAL(5,1) NOT NULL Duration Time
    13 DURATION_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Duration
    D=Days
    M=Months
    Y=Years
    14 ENTRY_DT Date(10) DATE This field pertains to the date a person enters a country on a specific visa.
    15 EXPIRATN_DT Date(10) DATE Expiration Date
    16 ISSUING_AUTHORITY Character(50) VARCHAR2(50) NOT NULL Issuing Authority
    17 HRS_HIRE_SEQ Number(10,0) DECIMAL(10) NOT NULL Hire Sequence ID