EMPLIDPrompt Table: HCR_PERSON_I
COUNTRYVISA_PERMIT_TYPESAD_SL_RESTP_VW(SQL View) |
Index Back |
|---|---|
Msg 51 Visa Type promptMsg 51 Visa Type prompt |
| SELECT A.EMPLID ,a.country ,a.VISA_PERMIT_TYPE ,B.DESCR ,D.SUPPORT_DOC_ID ,C.DESCR ,a.EFFDT FROM PS_SCC_VISAPMT_NLD A ,PS_HCR_VISA_PERM_I B ,PS_HCR_SUPPR_DOC_I C ,PS_SCC_VISASUP_NLD D WHERE A.EMPLID = D.EMPLID AND A.DEPENDENT_ID = D.DEPENDENT_ID AND A.COUNTRY = D.COUNTRY AND A.VISA_PERMIT_TYPE = D.VISA_PERMIT_TYPE AND A.EFFDT = D.EFFDT AND D.SAD_SL_DOCSL_NLD = 'Y' AND D.SUPPORT_DOC_ID = C.SUPPORT_DOC_ID AND %EffdtCheck(HCR_SUPPR_DOC_I C2,C,%CurrentDateIn) AND C.EFF_STATUS = 'A' AND B.COUNTRY = A.COUNTRY AND B.VISA_PERMIT_TYPE = A.VISA_PERMIT_TYPE AND %EffdtCheck(HCR_VISA_PERM_I B2,B,%CurrentDateIn) AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: HCR_PERSON_I |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | VISA_PERMIT_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Visa/Permit Type |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | SUPPORT_DOC_ID | Character(6) | VARCHAR2(6) NOT NULL | Supporting Document ID |
| 6 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 7 | ASOFDATE | Date(10) | DATE | As of Date |