OPRIDEMPLIDPrompt Table: GPFR_AT_SRCH1
EMPL_RCDORIG_BEGIN_DTAT=Industrial Accident
MP=Occupational Illness
Prompt Table: GPFR_AT_SRCH2
GPFR_AT_IN_SRCH(SQL View) |
Index Back |
|---|---|
ATMP: Search Record.ATMP: Search Record. |
| SELECT SEC.OPRID , A.EMPLID , A.EMPL_RCD , A.ORIG_BEGIN_DT , A.BGN_DT , A.END_DT , A.GPFR_AT_REASON , A.GB_GROUP_ID FROM PS_GPFR_AT_ADMIN A %Sql(GPFR_SECU_PERS_SQL, A) |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GPFR_AT_SRCH1 |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | ORIG_BEGIN_DT |
Date(10) | DATE | original begin date |
| 5 | BGN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | GPFR_AT_REASON | Character(2) | VARCHAR2(2) NOT NULL |
GPFR: Reason for Absence
AT=Industrial Accident MP=Occupational Illness |
| 8 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GPFR_AT_SRCH2 |