GPFR_DSN_AB_SEL

(SQL Table)
Index Back

Absence Event Employee list

Absence 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