GPIT_DM10_AET(SQL Table) |
Index Back |
|---|---|
Cache record for EE dataCache record for the Application Engine GPIT_DM10_AE. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | ASOFDATE | Date(10) | DATE |
As of Date
Default Value: %date |
| 5 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | EMPL_CLASS | Character(3) | VARCHAR2(3) NOT NULL | Employee Classification |
| 10 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time |
| 11 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 12 | END_DATE | Date(10) | DATE | End Date |
| 13 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 14 | PANEL_NAME | Character(18) | VARCHAR2(18) NOT NULL | Panel name |
| 15 | INPS_POS_CD_ITA | Character(4) | VARCHAR2(4) NOT NULL | INPS Position Code ITA |
| 16 | GPIT_INPS_CAT_ID | Character(1) | VARCHAR2(1) NOT NULL |
INPS Category
Prompt Table: GPIT_INPS_CAT |
| 17 | PART_TIME_PERC_ITA | Number(8,4) | DECIMAL(7,4) NOT NULL | Percentage of Part Time |
| 18 | GPIT_INPS_CDCTR_ID | Character(2) | VARCHAR2(2) NOT NULL |
INPS Contribution Code
Default Value: GPIT_INPS_PROF.GPIT_INPS_PROF_ID Prompt Table: GPIT_INPS_CDCTR |
| 19 | GPIT_DM10_RED_PAY | Character(1) | VARCHAR2(1) NOT NULL | Reduced Pay Flag... Created for the use in the DM10 process.... |
| 20 | GPIT_DM10_ARG_5 | Character(2) | VARCHAR2(2) NOT NULL | Argument 5 of DM10 Code.... |
| 21 | GPIT_DM10_ID | Character(6) | VARCHAR2(6) NOT NULL | Dm10 Code ID... Naming convention: X_YYYY |
| 22 | GPIT_DM10_GROUP | Character(4) | VARCHAR2(4) NOT NULL |
DM10 Group Code.
Prompt Table: GPIT_DM10_GROUP |
| 23 | GPIT_DM10_GRP_DESC | Character(30) | VARCHAR2(30) NOT NULL | Group Description. |
| 24 | GPIT_DM10_EE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Payee Counter Flag.
'Y'es: payee counted for the DM10.
'N'o: Payee not counted for the DM10.
Y/N Table Edit Default Value: N |
| 25 | GPIT_DM10_CAT_FROM | Character(1) | VARCHAR2(1) NOT NULL | Inps Category From value. |
| 26 | GPIT_DM10_CAT_TO | Character(1) | VARCHAR2(1) NOT NULL | Inps Category To: Illigibilty Value.... |
| 27 | GPIT_DM10_TIM_FROM | Number(8,4) | DECIMAL(7,4) NOT NULL | DM10 % Part time |
| 28 | GPIT_DM10_TIME_TO | Number(8,4) | DECIMAL(7,4) NOT NULL | DM10 % Part time To |
| 29 | GPIT_DM10_COD_FROM | Character(2) | VARCHAR2(2) NOT NULL | Contributive Codice From.... |
| 30 | GPIT_DM10_CODCE_TO | Character(2) | VARCHAR2(2) NOT NULL | DM10 Codice To Value |
| 31 | GPIT_DM10_EE_FROM | Character(1) | VARCHAR2(1) NOT NULL | Pay Reduction by Employee |
| 32 | GPIT_DM10_PAYEE_TO | Character(1) | VARCHAR2(1) NOT NULL | Pay reduction By EE |
| 33 | GPIT_DM10_KY5_FROM | Character(2) | VARCHAR2(2) NOT NULL | Argument 5 DM10: Value From |
| 34 | GPIT_DM10_KEY5_TO | Character(2) | VARCHAR2(2) NOT NULL | DM10 Key5: Value To |
| 35 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 36 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 37 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 38 | ORIG_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 39 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 40 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 41 | SLICE_BGN_DT | Date(10) | DATE | Element Slice Begin Date |
| 42 | SLICE_END_DT | Date(10) | DATE | Element Slice End Date |
| 43 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 44 | CALC_ADJ_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Adjustment Value |
| 45 | BASE_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculated Base Value |
| 46 | BASE_ADJ_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Base Adjustment |
| 47 | RATE_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 48 | UNIT_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Number of units used in result calculation |
| 49 | UNIT_ADJ_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Unit Adjustment |
| 50 | GPIT_DM10_COMP_ELM | Character(1) | VARCHAR2(1) NOT NULL |
Component Element
A=Amount Element Component B=Base Element Component R=Rate Element Component U=Unit Element Component |
| 51 | GPIT_DM10_ELM_TYPE | Character(3) | VARCHAR2(3) NOT NULL | DM10 element type.... |
| 52 | GPIT_PIN_DM10_NUM | Number(8,0) | INTEGER NOT NULL | DM10 Report Element Number |
| 53 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
| 54 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_TBL |
| 55 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 56 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPARTMENT_SRCH |
| 57 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 58 | TRGT_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Pay group to which retro deltas are targeted or forwarded |