OPRIDRUN_CNTL_IDSEQUENCENOCOMPANYEMPLIDGPIT_CUD_QUALIFGPIT_CUD_TIPOPTGPIT_CUD_TIPORAPPGPIT_CUD_ENTEINPS_CODE_ITAGPIT_INPS_CDCTR_IDGPIT_EVT_TYPEGPIT_ROW_NUMF=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
GPIT_CUD_RP_P1(SQL Table) |
Index Back |
|---|---|
Final table for CUD formTable which contains the final CUD form for each employee |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SEQUENCENO |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
| 4 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | GPIT_CUD_QUALIF |
Character(1) | VARCHAR2(1) NOT NULL | Field for CUD Report |
| 7 | GPIT_CUD_TIPOPT |
Character(1) | VARCHAR2(1) NOT NULL | Part time code for CUD |
| 8 | GPIT_CUD_TIPORAPP |
Character(1) | VARCHAR2(1) NOT NULL | Regular/temporary employees for CUD |
| 9 | GPIT_CUD_ENTE |
Character(2) | VARCHAR2(2) NOT NULL | Field that contains the value of the box 4 related to the Previdential CUD |
| 10 | INPS_CODE_ITA |
Character(12) | VARCHAR2(12) NOT NULL | INPS Code ITA |
| 11 | GPIT_INPS_CDCTR_ID |
Character(2) | VARCHAR2(2) NOT NULL | INPS Contribution Code |
| 12 | GPIT_EVT_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | Field for the Previdential CUD Report which is used to save the value of special payment in case of 'AS' or 'AE' |
| 13 | GPIT_ROW_NUM |
Number(3,0) | SMALLINT NOT NULL | Row Number for GP Italy |
| 14 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 15 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 16 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 17 | GPIT_CUD_PROVLAV | Character(2) | VARCHAR2(2) NOT NULL | It's the latest State of work in which the employee has worked during the year |
| 18 | GPIT_IVS_ASS | Character(1) | VARCHAR2(1) NOT NULL | This field contains the flag for the IVS Assurance. It's used in the Social Security CUD Report |
| 19 | GPIT_DS_ASS | Character(1) | VARCHAR2(1) NOT NULL | This field contains the flag for the DS Assurance. It's used in the Social Security CUD Report |
| 20 | GPIT_OTHER_ASS | Character(1) | VARCHAR2(1) NOT NULL | This field contains the flag for the OTHERS Assurances. It's used in the Social Security CUD Report |
| 21 | GPIT_FG_ASS | Character(1) | VARCHAR2(1) NOT NULL | This field contains the flag for the FG Assurance. It's used in the Social Security CUD Report |
| 22 | GPIT_COMPCORR_INC | Number(19,6) | DECIMAL(18,6) NOT NULL | INPS current payments income |
| 23 | GPIT_ALTRCOMP_INC | Number(19,6) | DECIMAL(18,6) NOT NULL | INPS other payments income |
| 24 | GPIT_CUD_SETT_INPS | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the value of INPS weeks summed for the period of the form |
| 25 | GPIT_CUD_GG_INPS | Number(3,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the value of INPS days summed for the period of the form |
| 26 | GPIT_CUD_TUTTIMESI | Character(1) | VARCHAR2(1) NOT NULL | Value of the Box 15 for the Previdential CUD |
| 27 | GPIT_CUD_JAN | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of January is or isn't a worked month for the Social Security CUD Report |
| 28 | GPIT_CUD_FEB | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of February is or isn't a worked month for the Social Security CUD Report |
| 29 | GPIT_CUD_MAR | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of March is or isn't a worked month for the Social Security CUD Report |
| 30 | GPIT_CUD_APR | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of April is or isn't a worked month for the Social Security CUD Report |
| 31 | GPIT_CUD_MAY | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of May is or isn't a worked month for the Social Security CUD Report |
| 32 | GPIT_CUD_JUN | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of June is or isn't a worked month for the Social Security CUD Report |
| 33 | GPIT_CUD_JUL | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of July is or isn't a worked month for the Social Security CUD Report |
| 34 | GPIT_CUD_AUG | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of August is or isn't a worked month for the Social Security CUD Report |
| 35 | GPIT_CUD_SEP | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of September is or isn't a worked month for the Social Security CUD Report |
| 36 | GPIT_CUD_OCT | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of October is or isn't a worked month for the Social Security CUD Report |
| 37 | GPIT_CUD_NOV | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of November is or isn't a worked month for the Social Security CUD Report |
| 38 | GPIT_CUD_DEC | Character(1) | VARCHAR2(1) NOT NULL | Field which defines if the month of December is or isn't a worked month for the Social Security CUD Report |
| 39 | GPIT_CUD_LABAGREEM | Character(3) | VARCHAR2(3) NOT NULL | Field for the Previdential CUD Report which contains the LABOR_AGREEMENT kept from the bracket GEN BR LABAGREEM |
| 40 | EMPL_CTG_L1 | Character(6) | VARCHAR2(6) NOT NULL | Employee Subcategory |
| 41 | GPIT_CUD_TERMDATE | Character(4) | VARCHAR2(4) NOT NULL | Termination Date for Previdential CUD Report |
| 42 | GPIT_CUD_TRASFRAP | Character(1) | VARCHAR2(1) NOT NULL | Value of the Box 22 for the Previdential CUD |
| 43 | GPIT_INPS_PTWEEKS | Number(5,2) | DECIMAL(4,2) NOT NULL | INPS part time weeks |
| 44 | GPIT_CUD_TFRFUND | Number(19,6) | DECIMAL(18,6) NOT NULL | Field for the Previdential CUD Report which contains the value of the TFR Fund accrued by the employee (box 24) |
| 45 | GPIT_CUD_ANFTABLE | Character(3) | VARCHAR2(3) NOT NULL | Field for the Previdential CUD Report which contains the value of the ANF Table (box 25) |
| 46 | GPIT_CUD_ANFCOMP | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the value of the ANF Family Components (box 26) |
| 47 | GPIT_CUD_ANFCLASS | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the value of the ANF Class (box 27) |
| 48 | GPIT_CUD_REDWEEKS | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the number of weeks with reduced payment (box 64) |
| 49 | GPIT_CUD_REDPAYMEN | Number(19,6) | DECIMAL(18,6) NOT NULL | Field for the Previdential CUD Report which contains the value of reduced payments (box 65) |
| 50 | GPIT_CUD_ABS_DED | Number(19,6) | DECIMAL(18,6) NOT NULL | Absence Deduction |
| 51 | GPIT_CUD_WEEK1SICK | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the number of weeks 1 for Sickness and/or work accident (box 67) |
| 52 | GPIT_CUD_WEEK2SICK | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the number of weeks 2 for Sickness and/or work accident (box 68) |
| 53 | GPIT_CUD_W1MATER | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the number of weeks 1 for Maternity L. 1204/71 (box 69) |
| 54 | GPIT_CUD_W2MATER | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the number of weeks 1 for Maternity L. 1204/71 (box 70) |
| 55 | GPIT_CUD_W1CIG | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the number of weeks 1 for CIG |
| 56 | GPIT_CUD_W2CIG | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the number of weeks 2 for CIG |
| 57 | GPIT_CUD_W1LAW53 | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the number of weeks 1 for Maternity L. 53/2000 (box 71) |
| 58 | GPIT_CUD_W2LAW53 | Number(5,2) | DECIMAL(4,2) NOT NULL | Field for the Previdential CUD Report which contains the number of weeks 2 for Maternity L. 53/2000 (box 72) |
| 59 | GPIT_CUD_WEEKBLOOD | Number(2,0) | SMALLINT NOT NULL | Field for the Previdential CUD Report which contains the number of weeks for Blood Donation (box 77) |
| 60 | GPIT_CUD_EMPLCTR | Number(19,6) | DECIMAL(18,6) NOT NULL | Empl. mandatory contributions. |
| 61 | GPIT_SBONUS_AMT | Number(9,0) | DECIMAL(9) NOT NULL | Amount |
| 62 | GPIT_CCC_BGN_DT | Date(10) | DATE | Field to be used as Begin Date. |
| 63 | GPIT_CCC_END_DT | Date(10) | DATE | Field to be used as End Date. |
| 64 | GPIT_CCC_COMP_CORR | Number(19,6) | DECIMAL(18,6) NOT NULL | Amount |
| 65 | GPIT_CCC_CONT_DOV | Number(19,6) | DECIMAL(18,6) NOT NULL | Amount |
| 66 | GPIT_CCC_CONT_TRAT | Number(19,6) | DECIMAL(18,6) NOT NULL | Amount |
| 67 | GPIT_CCC_CONT_VERS | Number(19,6) | DECIMAL(18,6) NOT NULL | Amount |
| 68 | HIRE_DT | Date(10) | DATE | First Start Date |
| 69 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 70 | COMP_CODE_ITA | Character(30) | VARCHAR2(30) NOT NULL | Company Codes ITA |
| 71 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 72 | CITY_ITA | Character(50) | VARCHAR2(50) NOT NULL | City for Italy |
| 73 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 74 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 75 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 76 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 77 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 78 | PHONE1 | Character(24) | VARCHAR2(24) NOT NULL | Phone number field for discounts and perks eligibility file. |
| 79 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 80 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 81 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 82 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 83 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 84 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 85 | BIRTHPLACE | Character(30) | VARCHAR2(30) NOT NULL | Birth Location |
| 86 | BIRTHSTATE | Character(6) | VARCHAR2(6) NOT NULL | Birth State |
| 87 | GPIT_FPC_TYP | Character(2) | VARCHAR2(2) NOT NULL | Complementary Fund Type |
| 88 | CITY50 | Character(50) | VARCHAR2(50) NOT NULL | City |
| 89 | STATE2 | Character(6) | VARCHAR2(6) NOT NULL | State |
| 90 | CITY_CD_FC_ITA | Character(4) | VARCHAR2(4) NOT NULL | Fiscal Code for City |
| 91 | PRINT_DATE | Date(10) | DATE | Print Date |
| 92 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 93 | DESCR50_1 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 94 | DESCRLONG | Long Character | CLOB | Long Description |