Wiki: IDGV

MAINTAIN GOVERNMENT REGISTRATIONS#

Government Registrations identify all the types of taxation and filing that must be done with each applicable government department or level.

Government registrations may be established and maintained through the Maintain Government Registrations (IDGV) form.

This form stores all levels of government registration numbers.

You may access this feature under the Screens/Forms menu: Payroll > Setup and Definitions > Maintain Government Registrations

Entity: Government registration codes are set up for each entity. Entity_Code from P2K_CM_ENTITIES is a 16-character alphanumeric mandatory field that the user may manually enter or use the LOV (F9) to choose an option.

Govt Regist Set: This field displays the name of the government registration set. You may use ‘Govt Registration Set’ to group similar registrations together.

: For example:

: Govt Regist Set - MAIN REGIST - Used by High Line as default to group all registrations initially.

: Govt Regist Set - REGIST 2 - User may define another set for all levels of registrations for this set.

: Govt Regist Set - FED REGIST - User may define Federal level registrations for this set.

: Govt Regist Set - STATE REGIST - User may define state level registrations for this set.

: Govt Regist Set - LOCAL REGIST - User may define local level registrations for this set.

: Govt Regist Set - FULLTIME REGIST - User may define registrations for full time employees for this set.

: Govt Regist Set - PARTTIME REGIST - User may define registrations for part time employees for this set.

: Govt Regist Set - SEASONAL REG - User may define registrations for seasonal employees for this set.

: Govt Regist Set - STATE OHIO - User may define registration for Ohio for this set.

: Govt_Regist_Set from P2K_CM_GOVT_REGIST_SETS is a 16-character alphanumeric mandatory field that the user may manually enter.

Description: Description is a description of the Govt Registration Set. Description from P2K_CM_GOVT_REGIST_SETS is a 50-character alphanumeric optional field that the user may manually enter.

Maintain Government Registrations (IDGV) - Definition#

Government Registration data is stored in the P2K_CM_GOVT_REGIST_SETS, P2K_CM_GOVT_REGISTRATIONS, P2K_CM_GOVT_RATES, and P2K_CM_GOVT_RATE_DETAILS tables.

Registration Type: The type of taxation for which a government registration has been created. Govt_Regist_Type is a mandatory fixed lexicon (X_GOVT_REGIST_TYPE) that you may use to look up the value.

Jurisdiction: The field is populated once you select the country, state/province or county, city, school district or jurisdiction.

Number: This is the US EIN or Canada BN number for this registration type. Govt_Regist_Number is a 30 character alphanumeric mandatory field that the user must manually enter.

Government Registration for Jurisdiction#

Only one of the following parameters may be completed per registrations. All of the fields are 16-character alphanumeric optional fields that you must manually enter or use the LOV (F9) to choose their option.

Country Name: The Country field from P2K_CM_COUNTRIES displays the country of registration.

State/Province: The State_Province field from P2K_CM_STATE_PROVINCES holds the state or province of registration.

County: The County field from P2K_CM_COUNTIES displays the county of registration. U.S. only

School District: The School_District field from P2K_CM_SCHOOL_DISTRICTS displays the school district of registration. U.S. only

Jurisdiction: The Tax_Jurisdiction field from P2K_CM_TAX_JURISDICTIONS displays the city or county of registration. U.S. only

Description: This is a user-defined description of the Government Registration. Description is a 50 character alphanumeric mandatory field that you must manually enter.

Distribution Mask CR: If the distribution credit mask needs to vary based on the state, local, etc. that the employee is being taxed in then the override needs to be placed here. Distribution_CR_Mask is an optional 50 character alphanumeric field that you may manually enter or use the LOV (F9).

Distribution Mask DR: If the distribution debit mask needs to vary based on the state, local, etc. that the employeeis being taxed in then the override needs to be placed here. Distribution_DR_Mask is a 50 character alphanumeric optional field that you may manually enter

Govt Rate Type: If the standard rate needs to be overridden then the type needs to be indicated. Govt_Rate_Type is a fixed lexicon (X_GOVT_RATE_TYPE) that the user may use to look up the value.

Description: User defined description of why the rate is being overridden. Description is a mandatory 50 character alphanumeric field that the user must manually enter.

Effective as of: This field displays the effective date of the override amount. Effective is a mandatory date field.

Expires on: This field displays the expiry date of the override amount. Expiry is a mandatory date field.

Amount $: The amount/rate/value of the override. Govt_Amount is 18-digit numeric field that the user must manually enter.

Change Reason: The reason for the change of rate is supplied here.