HRS_PERSON_IDHRS_PROFILE_SEQHRS_APP_ACMP_IDLANGUAGE_CDHRS_APP_MBR_LVW(SQL View) |
Index Back |
|---|---|
Appl Memberships - Rel Lng Vw |
| SELECT A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.HRS_APP_ACMP_ID ,C.LANGUAGE_CD ,C.MANDATE ,C.MANDATE_FUNCTION ,D.DESCR FROM PS_HRS_APP_ACMP A , PS_HRS_ACCOM_TBL_I B , PS_HRS_APP_ACM_LNG C , PS_HRS_ACC_TBL_LNI D WHERE A.ACCOMPLISHMENT = B.ACCOMPLISHMENT AND B.ACCOMP_CATEGORY = 'MEM' AND B.ACCOMPLISHMENT = D.ACCOMPLISHMENT AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = C.HRS_PROFILE_SEQ AND A.HRS_APP_ACMP_ID = C.HRS_APP_ACMP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | HRS_PROFILE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 3 | HRS_APP_ACMP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Accomplishment ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | MANDATE | Character(15) | VARCHAR2(15) NOT NULL | Mandate |
| 6 | MANDATE_FUNCTION | Character(15) | VARCHAR2(15) NOT NULL | Mandate Position |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |