EDIT_SHEET_AET(SQL Table) |
Index Back |
|---|---|
AE Cache for Employee SurveyThis cache record is used by the Application Engine HR_EMSURVEY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | TYPE_SHEET_CD_FRA | Character(2) | VARCHAR2(2) NOT NULL |
Used to regroup Employee Survey groups of indicators, based on legal requirement.
CT=Trade & Services Company ET=Trade & Services Establishment |
| 5 | INDIC_SHEET_CD_FRA | Character(5) | VARCHAR2(5) NOT NULL | Indicator |
| 6 | GROUP_SHEET_CD_FRA | Character(1) | VARCHAR2(1) NOT NULL | Indicator Group |
| 7 | INDIC_PARAM_CD_FRA | Character(5) | VARCHAR2(5) NOT NULL |
Indicator Parameter
Prompt Table: INDIC_SHEET_FRA |
| 8 | GROUP_PARAM_CD_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Indicator Group
Prompt Table: GROUP_SHEET_FRA |
| 9 | ASOFDATE | Date(10) | DATE | As of Date |
| 10 | MONTH_END_DT | Date(10) | DATE | Month End Date |
| 11 | VARIABLE_DATE | Date(10) | DATE | Variable Date |
| 12 | MONTHOFYEAR | Number(2,0) | SMALLINT NOT NULL | Month of Year |
| 13 | BEGINOFYEAR_FRA | Date(10) | DATE | Begin of Year |
| 14 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 15 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_TBL |
| 16 | TEXT20 | Character(20) | VARCHAR2(20) NOT NULL | Text (20 Characters) |
| 17 | ORGA_WHERE_CLAUSE | Character(100) | VARCHAR2(100) NOT NULL | Organization Where Clause |
| 18 | PRIM_WHER_CLAUSE_1 | Character(100) | VARCHAR2(100) NOT NULL | Used by Employee Survey Application Engine. |
| 19 | PRIM_WHER_CLAUSE_2 | Character(100) | VARCHAR2(100) NOT NULL | Used by Employee Survey Application Engine. |
| 20 | INDIC_WHERE_CLAUSE | Character(150) | VARCHAR2(150) NOT NULL | Use by the Employee Survey Application Engine to store SQL where clauses. |
| 21 | YEAR_NBR | Number(1,0) | SMALLINT NOT NULL | Years Number |
| 22 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 23 | AE_TEST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Test Flag |
| 24 | ENDOFPERIOD_FRA | Date(10) | DATE | End Of Period Date |
| 25 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 26 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 27 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 28 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 29 | THEORETICAL_DAYS | Number(8,2) | DECIMAL(7,2) NOT NULL | Theoretical Working Days |
| 30 | WORKING_HOURS | Number(8,2) | DECIMAL(7,2) NOT NULL | Working hours |
| 31 | LOST_DAYS | Number(8,2) | DECIMAL(7,2) NOT NULL | Lost Days |
| 32 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 33 | DURATION_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration (Hours) |
| 34 | AWAY_FROM_WORKDAYS | Number(4,0) | SMALLINT NOT NULL | Days Away From Work |
| 35 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Standard Work Period |
| 36 | BILAN_STAT_CD_FRA | Character(3) | VARCHAR2(3) NOT NULL |
Social Bilan Category
ASC=Acting Executive CAD=Executive EMN=Non Qualified Worker EMQ=Qualified Worker TEC=Technician |
| 37 | COUNTER | Signed Number(6,0) | DECIMAL(5) NOT NULL | Counter |
| 38 | FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field represent Full Time Equivalence |
| 39 | NVALUE_SHEET_1_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 1 |
| 40 | NVALUE_SHEET_2_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 2 |
| 41 | NVALUE_SHEET_3_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 3 |
| 42 | NVALUE_SHEET_4_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 4 |
| 43 | NVALUE_SHEET_5_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Count 5 |
| 44 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 45 | RETURN_DT | Date(10) | DATE | Return Date |
| 46 | GPFR_ES_WA_FIELD | Character(18) | VARCHAR2(18) NOT NULL | Writable Array Field |
| 47 | GPFR_ES_DATSRC | Character(1) | VARCHAR2(1) NOT NULL |
Translate Values for Data Source
0=Not Computed 1=Computed 2=Pay WA Field 3=Computed Pay WA Field 4=Absence WA Field 5=Computed Absence WA Field Default Value: 0 |
| 48 | FROM_WA_CLAUSE | Character(50) | VARCHAR2(50) NOT NULL | This field is to hold from clause |
| 49 | SELECT_WA_CLAUSE | Character(250) | VARCHAR2(250) NOT NULL | This field is to hold Select Clause |
| 50 | HAVING_WA_CLAUSE | Character(50) | VARCHAR2(50) NOT NULL | This field is to hold Having Clause |
| 51 | GPFR_ES_NVALUE1 | Number(19,6) | DECIMAL(18,6) NOT NULL | Count 1 |
| 52 | GPFR_ES_NVALUE2 | Number(19,6) | DECIMAL(18,6) NOT NULL | Count 2 |
| 53 | GPFR_ES_NVALUE3 | Number(19,6) | DECIMAL(18,6) NOT NULL | Count 3 |
| 54 | GPFR_ES_NVALUE4 | Number(19,6) | DECIMAL(18,6) NOT NULL | Count 4 |
| 55 | GPFR_ES_NVALUE5 | Number(19,6) | DECIMAL(18,6) NOT NULL | Count 5 |
| 56 | FISCAL_BEGIN_DT | Date(10) | DATE | Fiscal Begin Date |
| 57 | FISCAL_END_DT | Date(10) | DATE | Fiscal End Date |
| 58 | FISCAL_YR_FRA | Number(4,0) | SMALLINT NOT NULL | This field is used for initializing profit sharing dates |
| 59 | GPFR_ES_AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | WA AE Section |
| 60 | NVALUE_SHEET_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Use for EE Survey |
| 61 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |