GPFR_DSN_EE_SIT(SQL Table) |
Index Back |
|---|---|
DSN-Employee Situation DetailsApplication Framework - DSN Employee Situation Details Record |
| # | 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 |
| 4 | GPFR_AF_SNDREF |
Character(10) | VARCHAR2(10) NOT NULL | Application Framework - Sending Reference |
| 5 | GPFR_AF_NODE_SET |
Character(16) | VARCHAR2(16) NOT NULL | Application Framework - Node Set |
| 6 | GPFR_DSN_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | DSN Type |
| 7 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 8 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 9 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 10 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 11 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract Number
Default Value: 0 |
| 12 | GPFR_AF_SIT_BGN_DT |
Date(10) | DATE | Application Framework - Situation Begin Date |
| 13 | GPFR_DSN_EVT_RSN | Character(3) | VARCHAR2(3) NOT NULL | DSN event reason. |
| 14 | GPFR_AF_SND_LVL2 | Character(20) | VARCHAR2(20) NOT NULL | Sending Level |
| 15 | GPFR_AF_SIT_END_DT | Date(10) | DATE | Application Framework - Situation End Date |
| 16 | GPFR_AF_SIT_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Application Framework - Situation Status |
| 17 | CONTRACT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 18 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 19 | GPFR_AF_SITIND_HIR | Character(1) | VARCHAR2(1) NOT NULL | Application Framework - Situation Indicator Hire |
| 20 | GPFR_AF_SITIND_END | Character(1) | VARCHAR2(1) NOT NULL | Application Framework - End Situation Indicator |
| 21 | GPFR_AF_EXT_BGN_DT | Date(10) | DATE | Application Framework - Extraction Begin Date |
| 22 | GPFR_AF_EXT_END_DT | Date(10) | DATE | Application Framework - Extraction End Date |
| 23 | GPFR_AF_UF_01 | Character(50) | VARCHAR2(50) NOT NULL | User Fields |
| 24 | GPFR_AF_UF_02 | Character(50) | VARCHAR2(50) NOT NULL | User Fields |
| 25 | GPFR_AF_UF_03 | Character(50) | VARCHAR2(50) NOT NULL | User Fields |
| 26 | GPFR_AF_UF_04 | Character(50) | VARCHAR2(50) NOT NULL | User Fields |
| 27 | GPFR_AF_UF_05 | Character(50) | VARCHAR2(50) NOT NULL | User Fields |
| 28 | GPFR_AF_UF_06 | Character(50) | VARCHAR2(50) NOT NULL | User Fields |
| 29 | GPFR_AF_UF_07 | Character(50) | VARCHAR2(50) NOT NULL | User Fields |
| 30 | GPFR_AF_UF_08 | Character(50) | VARCHAR2(50) NOT NULL | User Fields |
| 31 | GPFR_AF_UF_09 | Character(50) | VARCHAR2(50) NOT NULL | User Fields |
| 32 | GPFR_AF_UF_10 | Character(50) | VARCHAR2(50) NOT NULL | User Fields |
| 33 | GPFR_CALC_TS_CHAR | Character(26) | VARCHAR2(26) NOT NULL | Indicates when something (a segment) was calculated |
| 34 | GPFR_DSN_IND_FIN | Character(1) | VARCHAR2(1) NOT NULL |
Sending reference extraction finalized
Y/N Table Edit Default Value: N |
| 35 | GPFR_DSN_EXT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
DSN extraction source
M=Manual P=Process Default Value: P |
| 36 | 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 |
| 37 | GPFR_DSN_DECL_REF | Character(15) | VARCHAR2(15) NOT NULL | DSN Declaration reference |
| 38 | GPFR_DSN_REPL_DECL | Character(15) | VARCHAR2(15) NOT NULL | DSN Event declaration reference to be replaced or cancelled |
| 39 | GPFR_DSN_REP_SD_DT | Date(10) | DATE | Replaced declaration send date |
| 40 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Datetime |