EMPLIDPrompt Table: GPFR_ILL_SRCH1
EMPL_RCDORIG_BEGIN_DTOPRID1=Illness
2=Maternity
3=Paternity
Prompt Table: GPFR_ILL_SRCH2
GPFR_IL_IN_SRCH(SQL View) |
Index Back |
|---|---|
ILL/MAT: Used as Search RecordILL/MAT: Used as Search Record |
| SELECT A.EMPLID , A.EMPL_RCD , A.ORIG_BEGIN_DT , SEC.OPRID , A.BGN_DT , A.END_DT , A.GPFR_ILL_REASON , A.GB_GROUP_ID FROM PS_GPFR_ILL_ADMIN A %Sql(GPFR_SECU_PERS_SQL, A) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GPFR_ILL_SRCH1 |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | ORIG_BEGIN_DT |
Date(10) | DATE | original begin date |
| 4 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | BGN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | GPFR_ILL_REASON | Character(1) | VARCHAR2(1) NOT NULL |
Different families of absence codes
1=Illness 2=Maternity 3=Paternity |
| 8 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GPFR_ILL_SRCH2 |