GPFR_DSN_AB_SEL(SQL Table) |
Index Back |
|---|---|
Absence Event Employee listAbsence Event Table for - Work Stoppages and Return to Work DSN events. List of employees to be proceessed by AF, either automatically selected or manually selected. Table structure based on GPFR_DSN_AB_TMP. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GPFR_EVT_WS_DVW |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | BGN_DT |
Date(10) | DATE NOT NULL |
Begin Date
Prompt Table: GPFR_EVT_BD_DVW |
| 4 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_AT0_VW |
| 5 | END_DT |
Date(10) | DATE | end date |
| 6 | GPFR_AF_EXTRACT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Application Framework - Extraction ID
Prompt Table: GPFR_EVT_EX_DVW |
| 7 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 8 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 9 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 10 | GPFR_DSN_ABS_RSN | Character(20) | VARCHAR2(20) NOT NULL | Captures absence reason code for DSN Norm. |
| 11 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Contract Type |
| 12 | GPFR_DA_STRUCT | Character(50) | VARCHAR2(50) NOT NULL | DADS related field |
| 13 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 14 | GPFR_AF_APPL | Character(10) | VARCHAR2(10) NOT NULL | Application Framework - Application |
| 15 | GPFR_AF_NODE_SET | Character(16) | VARCHAR2(16) NOT NULL |
Application Framework - Node Set
Default Value: DERIVED_GPFRDSN.GPFR_DSN_EVT_TYP |
| 16 | GPFR_DSN_IND_FIN | Character(1) | VARCHAR2(1) NOT NULL |
Sending reference extraction finalized
Y/N Table Edit Default Value: N |
| 17 | GPFR_DSN_EXT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
DSN extraction source
M=Manual P=Process Default Value: M |
| 18 | GPFR_DSN_EVT_EEACT | Character(1) | VARCHAR2(1) NOT NULL |
Field to decide the action for the employee: Report / Cancel and Replace / Cancel / Blank. Default is determined by application framework parameter CUSTOM / EVT_EE_SEL_ACTION. Blank means employee is not reported.
C=Cancel R=Replace S=Report |
| 19 | GPFR_DSN_DECL_REF | Character(15) | VARCHAR2(15) NOT NULL | DSN Declaration reference |
| 20 | GPFR_DSN_SEND_DT | Date(10) | DATE | DSN Event declaration send date |
| 21 | GPFR_DSN_REPL_DECL | Character(15) | VARCHAR2(15) NOT NULL |
DSN Event declaration reference to be replaced or cancelled
Prompt Table: %EDITTABLE |
| 22 | GPFR_DSN_REP_SD_DT | Date(10) | DATE | Replaced declaration send date |
| 23 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Datetime |