EMPLIDROWSECCLASSN=No Access
Y=Read/Write Access
Prompt Table: SETID_TBL
Prompt Table: PERS_DEPT_VW
PERS_SME_BRA_VW(SQL View) |
Index Back |
|---|---|
Medical Exam Results BrazilMedical Exam Results Search Record for Brazil |
| SELECT A.EMPLID %Sql(HRSECVIEWS_SELECT,SEC) ,JOB.EMPL_RCD ,B.NAME ,B.LAST_NAME_SRCH ,JOB.SETID_DEPT ,JOB.DEPTID ,B.NAME_AC FROM PS_PERSON A ,PS_PERSON_NAME B , PS_MED_EXAM_P_BRA C %Sql(HRSECVIEWS_JOBFROM,JOB) %Sql(HRSECVIEWS_FROM,SEC) A.EMPLID=B.EMPLID AND A.EMPLID = C.EMPLID AND B.EMPLID=JOB.EMPLID %Sql(HRSECVIEWS_JOB,JOB) %Sql(HRSECVIEWS_WHERE,SEC,JOB) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ROWSECCLASS |
Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 3 | ACCESS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Access Code
N=No Access Y=Read/Write Access |
| 4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department Set ID
Prompt Table: SETID_TBL |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: PERS_DEPT_VW |
| 9 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |