EMPLIDHRS_PERSON_IDHRS_PROFILE_SEQACCOMPLISHMENTDT_ISSUEDMAJOR_CODELANGUAGE_CDHRS_HIRELIC_LVW(SQL View) |
Index Back |
|---|---|
License&Certificate RelatedHRS_HIRELIC_LVW is the language record related to HRS_HIRE_LIC_VW |
| SELECT C.EMPLID , A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , D.ACCOMPLISHMENT , D.DT_ISSUED , D.MAJOR_CODE , A.LANGUAGE_CD ,A.ISSUED_BY FROM PS_HRS_APP_ACM_LNG A , PS_HRS_APP_ACMP D , PS_HCR_ACCOM_TBL_I B , PS_HRS_HIRE C WHERE D.HRS_PERSON_ID = A.HRS_PERSON_ID AND D.HRS_PROFILE_SEQ = A.HRS_PROFILE_SEQ AND A.HRS_APP_ACMP_ID =D.HRS_APP_ACMP_ID AND D.ACCOMPLISHMENT = B.ACCOMPLISHMENT AND B.ACCOMP_CATEGORY = 'LIC' AND D.HRS_PERSON_ID = C.HRS_PERSON_ID AND D.HRS_PROFILE_SEQ = C.HRS_PROFILE_SEQ |
| # | 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 | HRS_PROFILE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 4 | ACCOMPLISHMENT |
Character(8) | VARCHAR2(8) NOT NULL | Accomplishment |
| 5 | DT_ISSUED |
Date(10) | DATE | Issue Date |
| 6 | MAJOR_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Major Code |
| 7 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 8 | ISSUED_BY | Character(30) | VARCHAR2(30) NOT NULL | Issued By |