GVT_EE_2ND_SCH(SQL View) |
Index Back |
|---|---|
2nd Authorized SearchEMPLMT_SRCH_US is an Employment Search record containing the US SSN as an alternate search key. Use it to select employee records for you to use when you access a panel. This view shows you records only for employees in departments that your operator class is allowed to access. Use this view to access records with primary keys of EMPLID and EMPL_RCD#. To access records keyed by EMPLID without EMPL_RCD#, use one of ther Personal Searches. |
| SELECT DISTINCT %Sql(SCRTY_SEL_PKEY, OPR,SEC) , %Sql(SCRTY_SEL_USF_SBR,NM,SEC) FROM %Sql(SCRTY_PERUSF_FROM) , PS_GVT_PERS_DATA NM WHERE %Sql(SCRTY_WHERE_PPLUSF) AND %Sql(SCRTY_USF_WIP_WHERE,'USFED','2ND AUTH') AND NM.EMPLID = SEC.EMPLID AND NM.EMPL_RCD = SEC.EMPL_RCD AND NM.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GVT_PERS_DATA B WHERE B.EMPLID = NM.EMPLID AND B.EMPL_RCD = NM.EMPL_RCD AND B.EFFDT <= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | NAME_PSFORMAT | Character(50) | VARCHAR2(50) NOT NULL | A Person's name in the Peoplesoft Format (basically LN,FN MI |
| 7 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | SECOND_LAST_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 9 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 10 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 11 | SECOND_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 12 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 13 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 14 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 15 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 16 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department Set ID
Prompt Table: SETID_TBL |
| 17 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: PERS_DEPT_VW |
| 18 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 19 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 20 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 21 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 22 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 23 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
| 24 | GVT_WIP_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Work-in-Progress Status
Prompt Table: GVT_WIP_STS_VW |
| 25 | GVT_STATUS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress |
| 26 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Nature of Action Code
Prompt Table: GVT_NOAC_TBL |