CASE_OFFICER_GERLOC_CASEOFF_VW2(SQL View) |
Index Back |
|---|---|
View of Loc_caseoff_gerselecting only OFFICER_TYPE_GER = 'ARZ' Used as a prompt for ILLNESS_GER |
| SELECT A.CASE_OFFICER_GER , P.NAME FROM PS_HS_JOB_GER A , PS_PERSON_NAME P WHERE A.CASE_OFFICER_GER = P.EMPLID AND A.OFFICER_TYPE_GER = 'ARZ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CASE_OFFICER_GER |
Character(11) | VARCHAR2(11) NOT NULL | Case Officer ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |