TRN_2483_PARM(SQL Table) |
Index Back |
|---|---|
BT 2483 ParametersBT 2483 Supplementary RunControl Parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | DECL_YR_2483_FRA |
Number(4,0) | SMALLINT NOT NULL |
French Report 2483 : Declaring Year
Default Value: 2000 |
| 3 | GEN_TIME_2483_FRA | Number(6,2) | DECIMAL(5,2) NOT NULL | French Report 2483 : Time Reequired to be Charged |
| 4 | METHOD_2483_FRA | Character(1) | VARCHAR2(1) NOT NULL |
French Report 2483 : Salary Computation Method
M=Median P=Paid Salary T=Theoretical Default Value: M |
| 5 | C2_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Equipment Costs(2) |
| 6 | C6_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Training Demand Elaboration Expenses |
| 7 | FG_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Other Payments |
| 8 | FF_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Training Plan Payment |
| 9 | C9_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Training Time Saving Account Payment |
| 10 | D5_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Training Leave Payment (10) |
| 11 | FH_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Subsidies to Deduct (14) |
| 12 | FI_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Subsidies to Deduct (14) |
| 13 | D_TP_TSA_2483_FRA | Character(6) | VARCHAR2(6) NOT NULL |
GPFR: Trn Plan & Trn Saving Account
Prompt Table: TRN_2483_FFV_VW |
| 14 | D_BR_TRN_2483_FRA | Character(6) | VARCHAR2(6) NOT NULL |
French Report 2483 : Release Training
Prompt Table: TRN_2483_FFV_VW |
| 15 | D_PTL_2483_FRA | Character(6) | VARCHAR2(6) NOT NULL |
GPFR: Personal Training Leave
Prompt Table: TRN_2483_FFV_VW |
| 16 | I_WA_2068_2483_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Declaration 2068 |
| 17 | I_LM_2068_2483_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Limit Amount |
| 18 | C_PAY_FLG_2483_FRA | Character(1) | VARCHAR2(1) NOT NULL |
French Report 2483 : Interface with Payroll System
Y/N Table Edit Default Value: N |
| 19 | C2_RATE_2483_FRA | Number(6,2) | DECIMAL(5,2) NOT NULL | French Report 2483 : Participation Rate |
| 20 | C1_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Total Salaries |
| 21 | F1_WA_FLD_2483_FRA | Character(18) | VARCHAR2(18) NOT NULL |
French Report 2483 : Gross Salary WA
Default Value: GROSS_AMT Prompt Table: TRN2483_WAFLDVW |
| 22 | E7_RATE_2483_FRA | Number(6,2) | DECIMAL(5,2) NOT NULL | French Report 2483 : Participation Rate (Group G) |
| 23 | E9_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : OPCA Payment(11) |
| 24 | G12_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Inclusive Charge Expenses |
| 25 | D3_RATE_2483_FRA | Number(6,2) | DECIMAL(5,2) NOT NULL | French Report 2483 : Participation Rate |
| 26 | G_PAY_FLG_2483_FRA | Character(1) | VARCHAR2(1) NOT NULL |
French Report 2483 : Interface with Payroll System
Y/N Table Edit Default Value: N |
| 27 | G17_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Total Salaries for CDD |
| 28 | G16_WA_FLD2483_FRA | Character(18) | VARCHAR2(18) NOT NULL |
French Report 2483 : Gross Salary WA Field
Default Value: GROSS_AMT Prompt Table: TRN2483_WAFLDVW |
| 29 | G18_RATE_2483_FRA | Number(6,2) | DECIMAL(5,2) NOT NULL | French Report 2483 : Employee Rate |
| 30 | G19_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : OPCACIF Payment |
| 31 | H22_2483_AMT_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | French Report 2483 : Payment Regularization |
| 32 | H_WC_NUM_2483_FRA | Number(3,0) | SMALLINT NOT NULL | French Report 2483 : Number of Work Council Reports |
| 33 | H_IN_NUM_2483_FRA | Number(3,0) | SMALLINT NOT NULL |
French Report 2483 : Number of Insolvency Report
1/0 Table Edit (1=True, 0=False) Default Value: 0 |