HRS_PERSON_IDDefault Value: 0
OPRIDLANGUAGE_CDHRS_APP_SEC_LN(SQL View) |
Index Back |
|---|---|
Related Language RecordRelated Language Record for HRS_APP_sec_SCH |
| SELECT A.HRS_PERSON_ID , OPR.OPRID , PNL.LANGUAGE_CD , COALESCE (B_LNG.NAME_DISPLAY , B.NAME_DISPLAY) , COALESCE (C_LNG.DESCR , C.DESCR) FROM PS_HRS_APPLICANT A , (PS_HRS_APP_NAMES B LEFT OUTER JOIN PS_HRS_APP_NM_LNG B_LNG ON B.HRS_PERSON_ID = B_LNG.HRS_PERSON_ID AND B.NAME_TYPE = B_LNG.NAME_TYPE) , (PS_HRS_STS_TBL C LEFT OUTER JOIN PS_HRS_STS_LNG C_LNG ON C.STATUS_AREA = C_LNG.STATUS_AREA AND C.STATUS_CODE = C_LNG.STATUS_CODE) , PSPNLGDEFNLANG PNL , PSOPRDEFN OPR WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.STATUS_CODE = C.STATUS_CODE AND C.STATUS_AREA = '2' AND PNL.PNLGRPNAME = 'HRS_GACT_RCM_STS' AND (B_LNG.LANGUAGE_CD IS NULL OR B_LNG.LANGUAGE_CD = PNL.LANGUAGE_CD) AND (C_LNG.LANGUAGE_CD IS NULL OR C_LNG.LANGUAGE_CD = PNL.LANGUAGE_CD) AND EXISTS ( SELECT 'X' FROM PS_HRS_RCMNT D WHERE A.HRS_PERSON_ID = D.HRS_PERSON_ID AND HRS_LOGICAL_DELETE = 'N' AND (D.HRS_JOB_OPENING_ID=0 OR D.HRS_JOB_OPENING_ID IN ( SELECT TM.HRS_JOB_OPENING_ID FROM PS_HRS_JO_TEAM TM WHERE TM.EMPLID = OPR.EMPLID AND TM.HRS_JOB_OPENING_ID = D.HRS_JOB_OPENING_ID ) ) ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Person Id
Default Value: 0 |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |