GPES_SENDING_IDOPRIDEMPLIDEMPL_RCDGPES_SICK_DATEPA=Medical Discharge
PB=Sick Note
PC=Confirmation Sick Note
1=Included in FDI
N=No Communicated
Y=FDI Sent Confirmed
Default Value: N
GPES_FDI_NT_SVW(SQL View) |
Index Back |
|---|---|
FDI Employee Data w/ SecurityFDI Employee Data with Security |
| SELECT DISTINCT FDI.GPES_SENDING_ID , %Sql(SCRTY_SEL_PKEY, OPR,SEC) , FDI.GPES_SICK_DATE , FDI.GPES_FDI_NOTE_TYPE , FDI.BGN_DT , FDI.END_DT , FDI.PIN_TAKE_NUM , FDI.GPES_CONFIRM_SEND FROM %Sql(SCRTY_PER_FROM) , PS_GPES_ABSEVT_NT FDI WHERE %Sql(SCRTY_NO_APPT1) AND %Sql(SCRTY_WHERE, 'PPLJOB') AND SEC.EMPLID = FDI.EMPLID AND SEC.EMPL_RCD = FDI.EMPL_RCD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPES_SENDING_ID |
Character(10) | VARCHAR2(10) NOT NULL | Sending ID |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 6 | GPES_SICK_DATE |
Date(10) | DATE | Date to Sick note |
| 7 | GPES_FDI_NOTE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Type
PA=Medical Discharge PB=Sick Note PC=Confirmation Sick Note |
| 8 | BGN_DT | Date(10) | DATE NOT NULL | Begin Date |
| 9 | END_DT | Date(10) | DATE NOT NULL | end date |
| 10 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
| 11 | GPES_CONFIRM_SEND | Character(1) | VARCHAR2(1) NOT NULL |
Confirmed Send
1=Included in FDI N=No Communicated Y=FDI Sent Confirmed Default Value: N |