GPFR_DSN_AD_SEL(SQL Table) |
Index Back |
|---|---|
SADV Detail Employee ListApplication Framework - DSN Employee SADV Details Record. List of employees to be proceessed by AF, either automatically selected or manually selected. Table structure based on GPFR_DSN_EE_SIT. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | GPFR_AF_APPL |
Character(10) | VARCHAR2(10) NOT NULL | Application Framework - Application |
| 3 | GPFR_AF_EXTRACT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Application Framework - Extraction ID
Prompt Table: GPFR_EVT_EX_DVW |
| 4 | GPFR_AF_NODE_SET |
Character(16) | VARCHAR2(16) NOT NULL |
Application Framework - Node Set
Default Value: DERIVED_GPFRDSN.GPFR_DSN_EVT_TYP |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GPFR_EVT_AD_DVW |
| 6 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 7 | GPFR_DSN_EVT_DT |
Date(10) | DATE |
DSN event date
Prompt Table: GPFR_EVT_EV_DVW |
| 8 | GPFR_DSN_SADV_RSN | Character(3) | VARCHAR2(3) NOT NULL |
Variable Data Communication ('Signalement ADV') reason.
Prompt Table: GPFR_DT_DVAL_VW |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 10 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 11 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 12 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Contract Type |
| 13 | GPFR_DSN_IND_FIN | Character(1) | VARCHAR2(1) NOT NULL |
Sending reference extraction finalized
Y/N Table Edit Default Value: N |
| 14 | GPFR_DSN_EXT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
DSN extraction source
M=Manual P=Process Default Value: M |
| 15 | 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 |
| 16 | GPFR_DSN_DECL_REF | Character(15) | VARCHAR2(15) NOT NULL | DSN Declaration reference |
| 17 | GPFR_DSN_SEND_DT | Date(10) | DATE | DSN Event declaration send date |
| 18 | GPFR_DSN_REPL_DECL | Character(15) | VARCHAR2(15) NOT NULL |
DSN Event declaration reference to be replaced or cancelled
Prompt Table: %EDITTABLE |
| 19 | GPFR_DSN_REP_SD_DT | Date(10) | DATE | Replaced declaration send date |
| 20 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Datetime |