| Payroll - PAY_WC_FUNDS | Workers Compensation Funds table. |
|---|---|
| Column Name | Descritpion |
| FUND_ID | System generated primary key for WC Funds. |
| CALCULATION_METHOD2 | Calculation method for the second employer and employee components of |
| CALCULATION_METHOD3 | Calculation method for the third employer component ofworkers compensation. |
| BUSINESS_GROUP_ID | Foreign key to HR_ORGANIZATION_UNITS. |
| COMMENTS | General remark regarding this fund. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| CARRIER_ID | Foreign Key to HR_ORGANIZATION_UNITS. |
| LOCATION_ID | Foreign key to HR_LOCATIONS. |
| STATE_CODE | Foreign key to PAY_STATE_RULES. |
| CALCULATION_METHOD | Calculation method for the first employer and employee components of |
| Payroll - PAY_WC_RATES | Workers Compensation Rates table. |
|---|---|
| Column Name | Descritpion |
| WC_CODE | Workers Compensation code within a specific fund. This code is defined by the WC Carrier and applied to specific Jobs. |
| RATE3 | Rate for the third employer component for the corresponding WC code and the specific fund table. |
| RATE_EE | Rate for the first employee component for the corresponding WC code and the specific fund table. |
| RATE_EE2 | Rate for the second employee component for the corresponding WC code and the specific fund table. |
| PERIOD | The time period to be used for the corresponding code if the calculation methodis 'Flat Amount per period'. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| FUND_ID | Foreign Key to PAY_WC_FUNDS. |
| BUSINESS_GROUP_ID | System generated foreign key to HR_ORGANIZATION_UNITS. |
| RATE | Rate for the WC code for the specific fund table. |
| RATE2 | Rate for the second employer component for the corresponding WC code and the specific fund table. |
| Payroll - PAY_WC_STATE_SURCHARGES | Workers Compensation Surcharges table. |
|---|---|
| Column Name | Descritpion |
| SURCHARGE_ID | System generated primary key for PAY_WC_STATE_SURCHARGES. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| STATE_CODE | Foreign key to PAY_STATE_RULES. |
| ADD_TO_RT | Indicates whether to add the RATE to the running total calculated by the formula. |
| NAME | Name of the surcharge. |
| POSITION | Indicates the point within the WC formula calculation to apply the surcharge. |
| RATE | Actual amount of the surcharge. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| Payroll - PAY_US_STATES | US states and their VERTEX geocodes, used to validate US addresses. |
|---|---|
| Column Name | Descritpion |
| STATE_CODE | State geocode. |
| STATE_ABBREV | Abbreviation for state, eg. CA. |
| STATE_NAME | State name. |
| Payroll - PAY_US_ZIP_CODES | Valid zip code ranges for VERTEX cities, used to validate US addresses. |
|---|---|
| Column Name | Descritpion |
| ZIP_START | Start of zip code range. |
| ZIP_END | End of zip code range. |
| STATE_CODE | State geocode. Foreign key to PAY_US_COUNTIES. |
| COUNTY_CODE | County geocode. Foreign key to PAY_US_COUNTIES. |
| CITY_CODE | City geocode. Foreign key to PAY_US_CITY_GEOCODES. |
| Payroll - PAY_US_TAX_BALANCES | Tax balances used by US Payroll Tax balance reporting. |
|---|---|
| Column Name | Descritpion |
| TAX_BALANCE_ID | System-generated primary key column. |
| TAX_TYPE_ID | Foreign key to PAY_US_TAX_TYPES. |
| BALANCE_CATEGORY_CODE | Code indicating the balance category. |
| EE_OR_ER_CODE | Indicates whether the tax is Employee or Employer tax. |
| USER_REPORTING_NAME | Name for the tax balance displayed in reports. |
| BALANCE_TYPE_ID |
| Payroll - PAY_US_TAX_REPORT_BALANCES | Identifies tax balances for US Payroll Tax Summary Listing report. |
|---|---|
| Column Name | Descritpion |
| REPORT_CODE | Code representing the list of balances and balance dimensions to be reported. |
| TAX_BALANCE_ID | Foreign key to PAY_US_TAX_BALANCES. |
| BALANCE_PRINT_SEQUENCE | User defined sequence for printing the balances. |
| Payroll - PAY_US_TAX_REPORT_DIMENSIONS | Balance dimensions used by the US Payroll Tax Summary Listing report. |
|---|---|
| Column Name | Descritpion |
| REPORT_CODE | Code representing the list of balances and balance dimensions to be reported. |
| DIMENSION_CODE | Code representing the balance dimension to be reported. |
| Payroll - PAY_US_TAX_TYPES | US Tax Types used by US Payroll Tax Balance reporting. |
|---|---|
| Column Name | Descritpion |
| TAX_TYPE_ID | System-generated primary key column. |
| EE_ER_CODE | Code indicating whether the tax type is an Employee and/or Employer tax. |
| LIMIT_TAX_FLAG | Indicates whether the tax type is a limit tax. |
| TAX_DOMAIN_CODE | Indicates whether the tax type is a federal, state or local tax. |
| TAX_TYPE_CODE | Tax type code. |
| Payroll - PAY_US_GARN_LIMIT_RULES_F | Used for holding the Garnishment Limit Rules. |
|---|---|
| Column Name | Descritpion |
| LIMIT_RULE_ID | Part of the primary key |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| EFFECTIVE_START_DATE | Effective start date. |
| EFFECTIVE_END_DATE | Effective end date. |
| GARN_CATEGORY | Garnishment Category |
| STATE_CODE | State Geocode |
| MAX_WITHHOLDING_AMOUNT | Maximum Withholding amount |
| MAX_WITHHOLDING_DURATION_DAYS | Maximum Withholding Duration Days |
| MIN_WITHHOLDING_AMOUNT | Minimum Withholding Amount |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Payroll - PAY_US_GARN_FEE_RULES_F | Used for holding the Garnishment Fee rules |
|---|---|
| Column Name | Descritpion |
| FEE_RULE_ID | Part of the primary key |
| FEE_RULE | Fee Rule |
| MAX_FEE_AMOUNT | Maximum Fee Amount |
| PCT_CURRENT | Current Percentage |
| TAKE_FEE_ON_PRORATION | Take Fee |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| EFFECTIVE_START_DATE | Effective start date. |
| EFFECTIVE_END_DATE | Effective end date. |
| GARN_CATEGORY | Garnishment Category |
| STATE_CODE | State Geocode |
| ADDL_GARN_FEE_AMOUNT | Additional Garnishment Fee Amount |
| CORRESPONDENCE_FEE | Correspondence Fee |
| CREATOR_TYPE | Determines whether the record has been created by user or the system |
| FEE_AMOUNT | Fee Amount |
| Payroll - PAY_US_GARN_EXEMPTION_RULES_F | Used for holding the Garnishment Exemption Rules |
|---|---|
| Column Name | Descritpion |
| EXEMPTION_RULE_ID | Part of the primary key |
| DEPENDENTS_CALC_RULE | Dependents Calculation Rule |
| DEPENDENT_AMOUNT_VALUE | Dependent Amount Value |
| DI_PCT | DI Percentage |
| DI_PCT_DEPENDENTS | DI percentage for dependents |
| DI_PCT_DEPENDENTS_IN_ARREARS | DI percentage for dependents in arrears |
| DI_PCT_IN_ARREARS | DI percentage in arrears |
| EXEMPTION_BALANCE | Exemption Balance |
| EXEMPTION_BALANCE_MAX_PCT | Exemption Balance maximum percentage |
| EXEMPTION_BALANCE_MIN_PCT | Exemption balance minimum percentage |
| MARITAL_STATUS | Marital Status |
| EFFECTIVE_START_DATE | Effective start date. |
| MIN_WAGE_FACTOR | Minimum Wage Factor |
| PRORATION_RULE | Proration Rule |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| EFFECTIVE_END_DATE | Effective end date. |
| GARN_CATEGORY | Garnishment Category |
| STATE_CODE | State Geocode |
| ADDL_DEP_AMOUNT_VALUE | Additional Dependents amount value |
| AMOUNT_VALUE | Amount Value |
| CALC_RULE | Calculation Rule |
| CREATOR_TYPE | To see if system or user created |
| Payroll - PAY_US_GARN_ARREARS_RULES_F | Used for holding the Garnishment Arrears Rules |
|---|---|
| Column Name | Descritpion |
| ARREARS_RULE_ID | Part of the primary key |
| MIN_PCT_CURRENT | Current Minimum Percentage. |
| MIN_PCT_DI | Minimum percentage DI |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| EFFECTIVE_START_DATE | Effective start date. |
| EFFECTIVE_END_DATE | Effective end date. |
| GARN_CATEGORY | Garnishment Category |
| STATE_CODE | State Geocode |
| CALC_RULE | Calculation Rule |
| CREATOR_TYPE | Used to determine whether the record has been created by the user of the system |
| MAX_PCT_CURRENT | Current Maximum Percentage |
| MAX_PCT_DI | Maximum percentage DI |
| Payroll - PER_PAY_PROPOSAL_COMPONENTS | Component details of a pay proposal for an employee assignment. |
|---|---|
| Column Name | Descritpion |
| COMPONENT_ID | System-generated primary key column. |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure definition column. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| PAY_PROPOSAL_ID | Foreign key to PER_PAY_PROPOSALS. |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield column. |
| ATTRIBUTE17 | Descriptive flexfield column. |
| ATTRIBUTE18 | Descriptive flexfield column. |
| ATTRIBUTE19 | Descriptive flexfield column. |
| BUSINESS_GROUP_ID | Foreign key to HR_ORGANIZATION_UNITS. |
| ATTRIBUTE20 | Descriptive flexfield column. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| OBJECT_VERSION_NUMBER | System-generated version of row. Increments by one with each update. |
| CHANGE_AMOUNT | Change amount, to be applied to the last approved salary. Replaced by change_amount_n in 11.5 |
| APPROVED | Flag indicating whether component has been approved or not. |
| COMPONENT_REASON | Reason/name of the component (same domain as for proposal reason). |
| CHANGE_AMOUNT_N | The amount that the component changes the salary proposal. Replaces CHANGE_AMOUNT in 11.5 |
| CHANGE_PERCENTAGE | Change percentage, to be applied to the last approved salary. |
| COMMENTS | General remark. |
| NEW_AMOUNT | No longer used and should be set to null. |
| Payroll - PAY_US_EMP_FED_TAX_RULES_F | Federal level tax details for employee assignments. |
|---|---|
| Column Name | Descritpion |
| FED_INFORMATION22 | Developer descriptive flexfield column. |
| ATTRIBUTE8 | Descriptive flexfield segment |
| FED_INFORMATION23 | Developer descriptive flexfield column. |
| FED_INFORMATION24 | Developer descriptive flexfield column. |
| ATTRIBUTE29 | Descriptive flexfield column. |
| FED_INFORMATION25 | Developer descriptive flexfield column. |
| FED_INFORMATION26 | Developer descriptive flexfield column. |
| FED_INFORMATION27 | Developer descriptive flexfield column. |
| ATTRIBUTE30 | Descriptive flexfield column. |
| FED_INFORMATION28 | Developer descriptive flexfield column. |
| FED_INFORMATION29 | Developer descriptive flexfield column. |
| FED_INFORMATION_CATEGORY | Developer descriptive flexfield structure definition column. |
| FED_INFORMATION30 | Developer descriptive flexfield column. |
| FED_INFORMATION1 | Developer descriptive flexfield column. |
| FED_INFORMATION2 | Developer descriptive flexfield column. |
| FED_INFORMATION3 | Developer descriptive flexfield column. |
| FED_INFORMATION4 | Developer descriptive flexfield column. |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE26 | Descriptive flexfield column. |
| W2_FILED_YEAR | The year W2 was filed. |
| SUPP_TAX_OVERRIDE_RATE | Supplemental override rate. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| SUI_JURISDICTION_CODE | Format XX-YYY-ZZZZ: XX - State, YYY - County, ZZZZ - City. |
| BUSINESS_GROUP_ID | Foreign key to HR_ORGANIZATION_UNITS. |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ADDITIONAL_WA_AMOUNT | The extra W4 withholding allowance amount. |
| ATTRIBUTE11 | Descriptive flexfield segment |
| FILING_STATUS_CODE | The W4 filing status code. |
| ATTRIBUTE12 | Descriptive flexfield segment |
| FIT_OVERRIDE_AMOUNT | Federal income tax override amount. |
| FIT_OVERRIDE_RATE | Federal income tax override rate (%). |
| ATTRIBUTE13 | Descriptive flexfield segment |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| ATTRIBUTE14 | Descriptive flexfield segment |
| WITHHOLDING_ALLOWANCES | W4 withholding allowance amount. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CUMULATIVE_TAXATION | Cumulative taxation flag - Y if cumulative, N if not. |
| EIC_FILING_STATUS_CODE | EIC filing status code. |
| ATTRIBUTE15 | Descriptive flexfield segment |
| FIT_ADDITIONAL_TAX | Federal Income Tax additional tax. |
| FIT_EXEMPT | Federal income tax exemption flag - Y if exempt, N if not. |
| ATTRIBUTE16 | Descriptive flexfield column. |
| FUTA_TAX_EXEMPT | FUTA exemption flag - Y if exempt, N if not. |
| MEDICARE_TAX_EXEMPT | MEDICARE exemption flag - Y if exempt, N if not. |
| ATTRIBUTE17 | Descriptive flexfield column. |
| SS_TAX_EXEMPT | SS exemption flag - Y if exempt, N if not. |
| ATTRIBUTE18 | Descriptive flexfield column. |
| ATTRIBUTE19 | Descriptive flexfield column. |
| WAGE_EXEMPT | |
| ATTRIBUTE20 | Descriptive flexfield column. |
| ATTRIBUTE21 | Descriptive flexfield segment |
| ATTRIBUTE22 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE23 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| ATTRIBUTE24 | Descriptive flexfield segment |
| ATTRIBUTE25 | Descriptive flexfield segment |
| OBJECT_VERSION_NUMBER | System-generated version of row. Increments by one with each update. |
| EMP_FED_TAX_RULE_ID | System-generated primary key column. |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure definition column. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| EFFECTIVE_START_DATE | Effective start date. |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ATTRIBUTE6 | Descriptive flexfield segment |
| EXCESSIVE_WA_REJECT_DATE | The allowances reject date. |
| STATUTORY_EMPLOYEE | Statutory employee flag - Y if statutory employee, N if not. |
| ATTRIBUTE27 | Descriptive flexfield column. |
| FED_INFORMATION5 | Developer descriptive flexfield column. |
| EFFECTIVE_END_DATE | Effective end date. |
| FED_INFORMATION6 | Developer descriptive flexfield column. |
| FED_INFORMATION7 | Developer descriptive flexfield column. |
| FED_INFORMATION8 | Developer descriptive flexfield column. |
| FED_INFORMATION9 | Developer descriptive flexfield column. |
| FED_INFORMATION10 | Developer descriptive flexfield column. |
| ASSIGNMENT_ID | Foreign key to PER_ASSIGNMENTS. |
| FED_INFORMATION12 | Developer descriptive flexfield column. |
| ATTRIBUTE7 | Descriptive flexfield segment |
| FED_INFORMATION13 | Developer descriptive flexfield column. |
| FED_INFORMATION14 | Developer descriptive flexfield column. |
| FED_INFORMATION15 | Developer descriptive flexfield column. |
| ATTRIBUTE28 | Descriptive flexfield column. |
| SUI_STATE_CODE | Foreign key to PAY_STATE_RULES. |
| FED_INFORMATION17 | Developer descriptive flexfield column. |
| FED_INFORMATION11 | Developer descriptive flexfield column. |
| FED_INFORMATION18 | Developer descriptive flexfield column. |
| FED_INFORMATION19 | Developer descriptive flexfield column. |
| FED_INFORMATION20 | Developer descriptive flexfield column. |
| FED_INFORMATION16 | Developer descriptive flexfield column. |
| FED_INFORMATION21 | Developer descriptive flexfield column. |
| Payroll - PAY_US_EMP_STATE_TAX_RULES_F | State level tax details for employee assignments. |
|---|---|
| Column Name | Descritpion |
| EMP_STATE_TAX_RULE_ID | System-generated primary key column. |
| STA_INFORMATION25 | Developer descriptive flexfield column. |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE30 | Descriptive flexfield column. |
| STA_INFORMATION26 | Developer descriptive flexfield column. |
| STA_INFORMATION_CATEGORY | Developer descriptive flexfield structure definition column. |
| STA_INFORMATION1 | Developer descriptive flexfield column. |
| STA_INFORMATION27 | Developer descriptive flexfield column. |
| ADDITIONAL_WA_AMOUNT | Extra W4 withholding allowance amount. |
| STA_INFORMATION28 | Developer descriptive flexfield column. |
| STA_INFORMATION2 | Developer descriptive flexfield column. |
| STA_INFORMATION29 | Developer descriptive flexfield column. |
| STA_INFORMATION30 | Developer descriptive flexfield column. |
| STA_INFORMATION3 | Developer descriptive flexfield column. |
| STA_INFORMATION4 | Developer descriptive flexfield column. |
| STA_INFORMATION5 | Developer descriptive flexfield column. |
| ATTRIBUTE27 | Descriptive flexfield column. |
| FILING_STATUS_CODE | W4 filing status code. |
| ATTRIBUTE10 | Descriptive flexfield segment |
| REMAINDER_PERCENT | Remainder percent. |
| SECONDARY_WA | W4 secondary allowance. |
| ATTRIBUTE11 | Descriptive flexfield segment |
| SIT_ADDITIONAL_TAX | W4 additional state income tax. |
| SIT_OVERRIDE_AMOUNT | State income tax override amount. |
| ATTRIBUTE12 | Descriptive flexfield segment |
| SIT_OVERRIDE_RATE | State income tax override rate (%). |
| ATTRIBUTE13 | Descriptive flexfield segment |
| WITHHOLDING_ALLOWANCES | W4 withholding allowance. |
| EFFECTIVE_START_DATE | Effective start date. |
| EXCESSIVE_WA_REJECT_DATE | The allowances reject date. |
| ATTRIBUTE14 | Descriptive flexfield segment |
| OBJECT_VERSION_NUMBER | System-generated version of row. Increments by one with each update. |
| SDI_EXEMPT | SDI exempt flag - Y if exempt, N if not. |
| SIT_EXEMPT | State income tax exempt flag - Y if exempt, N if not. |
| ATTRIBUTE15 | Descriptive flexfield segment |
| SIT_OPTIONAL_CALC_IND | W4 state income tax optional calculation code. |
| STATE_NON_RESIDENT_CERT | Y if the assignment has a state non-resident certificate flag, else N. |
| ATTRIBUTE16 | Descriptive flexfield column. |
| SUI_EXEMPT | SUI exempt flag - Y if exempt, N if not. |
| ATTRIBUTE17 | Descriptive flexfield column. |
| WC_EXEMPT | Workers Compensation exemption flag - Y if exempt, N if not. |
| ATTRIBUTE18 | Descriptive flexfield column. |
| EFFECTIVE_END_DATE | Effective end date. |
| ATTRIBUTE19 | Descriptive flexfield column. |
| WAGE_EXEMPT | |
| ATTRIBUTE20 | Descriptive flexfield column. |
| SUI_WAGE_BASE_OVERRIDE_AMOUNT | SUI wage limit. |
| ATTRIBUTE21 | Descriptive flexfield segment |
| SUPP_TAX_OVERRIDE_RATE | Supplemental override rate. |
| ATTRIBUTE22 | Descriptive flexfield segment |
| ATTRIBUTE23 | Descriptive flexfield segment |
| ASSIGNMENT_ID | Foreign key to PER_ASSIGNMENTS. |
| ATTRIBUTE24 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| ATTRIBUTE25 | Descriptive flexfield segment |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| ATTRIBUTE26 | Descriptive flexfield column. |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure definition column. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| STATE_CODE | Foreign key to PAY_STATE_RULES. |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE28 | Descriptive flexfield column. |
| STA_INFORMATION6 | Developer descriptive flexfield column. |
| STA_INFORMATION7 | Developer descriptive flexfield column. |
| STA_INFORMATION8 | Developer descriptive flexfield column. |
| JURISDICTION_CODE | Format XX-YYY-ZZZZ: XX - State, YYY - County, ZZZZ - City. |
| STA_INFORMATION9 | Developer descriptive flexfield column. |
| STA_INFORMATION10 | Developer descriptive flexfield column. |
| STA_INFORMATION11 | Developer descriptive flexfield column. |
| STA_INFORMATION13 | Developer descriptive flexfield column. |
| STA_INFORMATION14 | Developer descriptive flexfield column. |
| BUSINESS_GROUP_ID | Foreign key to HR_ORGANIZATION_UNITS. |
| STA_INFORMATION15 | Developer descriptive flexfield column. |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE29 | Descriptive flexfield column. |
| STA_INFORMATION16 | Developer descriptive flexfield column. |
| STA_INFORMATION18 | Developer descriptive flexfield column. |
| STA_INFORMATION19 | Developer descriptive flexfield column. |
| STA_INFORMATION20 | Developer descriptive flexfield column. |
| STA_INFORMATION12 | Developer descriptive flexfield column. |
| STA_INFORMATION21 | Developer descriptive flexfield column. |
| STA_INFORMATION22 | Developer descriptive flexfield column. |
| STA_INFORMATION23 | Developer descriptive flexfield column. |
| STA_INFORMATION17 | Developer descriptive flexfield column. |
| STA_INFORMATION24 | Developer descriptive flexfield column. |
| Payroll - PAY_US_EMP_COUNTY_TAX_RULES_F | County level tax details for employee assignments. |
|---|---|
| Column Name | Descritpion |
| BUSINESS_GROUP_ID | Foreign key to HR_ORGANIZATION_UNITS. |
| CNT_INFORMATION25 | Developer descriptive flexfield column. |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE30 | Descriptive flexfield column. |
| CNT_INFORMATION_CATEGORY | Developer descriptive flexfield structure definition column. |
| CNT_INFORMATION1 | Developer descriptive flexfield column. |
| CNT_INFORMATION2 | Developer descriptive flexfield column. |
| CNT_INFORMATION26 | Developer descriptive flexfield column. |
| ADDITIONAL_WA_RATE | Extra W4 withholding allowance percentage rate. |
| CNT_INFORMATION27 | Developer descriptive flexfield column. |
| CNT_INFORMATION3 | Developer descriptive flexfield column. |
| CNT_INFORMATION28 | Developer descriptive flexfield column. |
| CNT_INFORMATION29 | Developer descriptive flexfield column. |
| CNT_INFORMATION4 | Developer descriptive flexfield column. |
| CNT_INFORMATION30 | Developer descriptive flexfield column. |
| ATTRIBUTE26 | Descriptive flexfield column. |
| FILING_STATUS_CODE | The W4 filing status code. |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| JURISDICTION_CODE | Format XX-YYY-ZZZZ: XX - State, YYY - County, ZZZZ - City. |
| LIT_ADDITIONAL_TAX | W4 additional local income tax. |
| ATTRIBUTE11 | Descriptive flexfield segment |
| LIT_OVERRIDE_AMOUNT | Local income tax override amount. |
| ATTRIBUTE12 | Descriptive flexfield segment |
| LIT_OVERRIDE_RATE | Local income tax override rate percentage. |
| ATTRIBUTE13 | Descriptive flexfield segment |
| CREATION_DATE | Standard who column - date when this row was created. |
| WITHHOLDING_ALLOWANCES | W4 withholding allowance. |
| ATTRIBUTE14 | Descriptive flexfield segment |
| LIT_EXEMPT | Local Income Tax exempt flag - Y if exempt, N if not. |
| ATTRIBUTE15 | Descriptive flexfield segment |
| SD_EXEMPT | School District tax exemption flag - Y if exempt, N if not. |
| ATTRIBUTE16 | Descriptive flexfield column. |
| HT_EXEMPT | Head Tax exemption flag - Y if exempt, N if not. |
| ATTRIBUTE17 | Descriptive flexfield column. |
| EMP_COUNTY_TAX_RULE_ID | System-generated primary key column. |
| ATTRIBUTE18 | Descriptive flexfield column. |
| WAGE_EXEMPT | |
| ATTRIBUTE19 | Descriptive flexfield column. |
| SCHOOL_DISTRICT_CODE | Foreign key to PAY_US_CITY_SCHOOL_DSTS. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| ATTRIBUTE20 | Descriptive flexfield column. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ATTRIBUTE21 | Descriptive flexfield segment |
| ATTRIBUTE22 | Descriptive flexfield segment |
| EFFECTIVE_START_DATE | Effective start date. |
| ATTRIBUTE23 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE24 | Descriptive flexfield segment |
| OBJECT_VERSION_NUMBER | System-generated version of row. Increments by one with each update. |
| ATTRIBUTE25 | Descriptive flexfield segment |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure definition column. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| EFFECTIVE_END_DATE | Effective end date. |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| ATTRIBUTE27 | Descriptive flexfield column. |
| ASSIGNMENT_ID | Foreign key to PER_ASSIGNMENTS. |
| CNT_INFORMATION5 | Developer descriptive flexfield column. |
| ATTRIBUTE6 | Descriptive flexfield segment |
| CNT_INFORMATION6 | Developer descriptive flexfield column. |
| CNT_INFORMATION7 | Developer descriptive flexfield column. |
| CNT_INFORMATION8 | Developer descriptive flexfield column. |
| CNT_INFORMATION9 | Developer descriptive flexfield column. |
| STATE_CODE | Foreign key to PAY_STATE_RULES. |
| CNT_INFORMATION10 | Developer descriptive flexfield column. |
| CNT_INFORMATION12 | Developer descriptive flexfield column. |
| CNT_INFORMATION13 | Developer descriptive flexfield column. |
| CNT_INFORMATION14 | Developer descriptive flexfield column. |
| CNT_INFORMATION15 | Developer descriptive flexfield column. |
| ATTRIBUTE28 | Descriptive flexfield column. |
| ATTRIBUTE7 | Descriptive flexfield segment |
| CNT_INFORMATION17 | Developer descriptive flexfield column. |
| CNT_INFORMATION18 | Developer descriptive flexfield column. |
| CNT_INFORMATION19 | Developer descriptive flexfield column. |
| CNT_INFORMATION20 | Developer descriptive flexfield column. |
| COUNTY_CODE | Foreign key to PAY_US_COUNTIES. |
| CNT_INFORMATION21 | Developer descriptive flexfield column. |
| CNT_INFORMATION11 | Developer descriptive flexfield column. |
| CNT_INFORMATION22 | Developer descriptive flexfield column. |
| CNT_INFORMATION23 | Developer descriptive flexfield column. |
| CNT_INFORMATION24 | Developer descriptive flexfield column. |
| CNT_INFORMATION16 | Developer descriptive flexfield column. |
| ATTRIBUTE29 | Descriptive flexfield column. |
| Payroll - PAY_US_EMP_CITY_TAX_RULES_F | City level tax details for employee assignments. |
|---|---|
| Column Name | Descritpion |
| STATE_CODE | Foreign key to PAY_US_COUNTIES. |
| CTY_INFORMATION22 | Developer descriptive flexfield column. |
| ATTRIBUTE9 | Descriptive flexfield segment |
| CTY_INFORMATION23 | Developer descriptive flexfield column. |
| CTY_INFORMATION24 | Developer descriptive flexfield column. |
| CTY_INFORMATION25 | Developer descriptive flexfield column. |
| ATTRIBUTE30 | Descriptive flexfield column. |
| CTY_INFORMATION27 | Developer descriptive flexfield column. |
| CTY_INFORMATION28 | Developer descriptive flexfield column. |
| CTY_INFORMATION26 | Developer descriptive flexfield column. |
| CTY_INFORMATION29 | Developer descriptive flexfield column. |
| CTY_INFORMATION30 | Developer descriptive flexfield column. |
| CTY_INFORMATION_CATEGORY | Developer descriptive flexfield structure definition column. |
| CTY_INFORMATION1 | Developer descriptive flexfield column. |
| CTY_INFORMATION2 | Developer descriptive flexfield column. |
| CTY_INFORMATION3 | Developer descriptive flexfield column. |
| COUNTY_CODE | Foreign key to PAY_US_COUNTIES. |
| CTY_INFORMATION4 | Developer descriptive flexfield column. |
| ATTRIBUTE10 | Descriptive flexfield segment |
| CTY_INFORMATION5 | Developer descriptive flexfield column. |
| ATTRIBUTE27 | Descriptive flexfield column. |
| WAGE_EXEMPT | |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| CITY_CODE | Foreign key to PAY_US_CITY_GEOCODES. |
| ATTRIBUTE11 | Descriptive flexfield segment |
| BUSINESS_GROUP_ID | Foreign key to HR_ORGANIZATION_UNITS. |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ADDITIONAL_WA_RATE | Extra W4 withholding allowance percentage rate. |
| ATTRIBUTE13 | Descriptive flexfield segment |
| EMP_CITY_TAX_RULE_ID | System-generated primary key column. |
| FILING_STATUS_CODE | The W4 filing status code. |
| ATTRIBUTE14 | Descriptive flexfield segment |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| JURISDICTION_CODE | Format XX-YYY-ZZZZ: XX - State, YYY - County, ZZZZ - City. |
| ATTRIBUTE15 | Descriptive flexfield segment |
| LIT_ADDITIONAL_TAX | W4 additional local income tax. |
| CREATION_DATE | Standard who column - date when this row was created. |
| LIT_OVERRIDE_AMOUNT | Local income tax override amount. |
| ATTRIBUTE16 | Descriptive flexfield column. |
| LIT_OVERRIDE_RATE | Local income tax override rate. |
| ATTRIBUTE17 | Descriptive flexfield column. |
| WITHHOLDING_ALLOWANCES | W4 withholding allowance amount. |
| ATTRIBUTE18 | Descriptive flexfield column. |
| LIT_EXEMPT | Local income tax exemption flag - Y if exempt, N if not. |
| ATTRIBUTE19 | Descriptive flexfield column. |
| SD_EXEMPT | School District tax exemption flag - Y if exempt, N if not. |
| ATTRIBUTE20 | Descriptive flexfield column. |
| HT_EXEMPT | Head Tax exemption flag - Y if exempt, N if not. |
| ATTRIBUTE21 | Descriptive flexfield segment |
| ATTRIBUTE22 | Descriptive flexfield segment |
| EFFECTIVE_START_DATE | Effective start date. |
| ATTRIBUTE23 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE24 | Descriptive flexfield segment |
| ATTRIBUTE25 | Descriptive flexfield segment |
| OBJECT_VERSION_NUMBER | System-generated version of row. Increments by one with each update. |
| ATTRIBUTE26 | Descriptive flexfield column. |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure definition column. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| EFFECTIVE_END_DATE | Effective end date. |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| SCHOOL_DISTRICT_CODE | Foreign key to PAY_US_CITY_SCHOOL_DSTS. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| ATTRIBUTE28 | Descriptive flexfield column. |
| CTY_INFORMATION6 | Developer descriptive flexfield column. |
| CTY_INFORMATION7 | Developer descriptive flexfield column. |
| CTY_INFORMATION8 | Developer descriptive flexfield column. |
| CTY_INFORMATION9 | Developer descriptive flexfield column. |
| CTY_INFORMATION10 | Developer descriptive flexfield column. |
| ASSIGNMENT_ID | Foreign key to PER_ASSIGNMENTS. |
| CTY_INFORMATION11 | Developer descriptive flexfield column. |
| ATTRIBUTE8 | Descriptive flexfield segment |
| CTY_INFORMATION13 | Developer descriptive flexfield column. |
| CTY_INFORMATION14 | Developer descriptive flexfield column. |
| CTY_INFORMATION15 | Developer descriptive flexfield column. |
| ATTRIBUTE29 | Descriptive flexfield column. |
| CTY_INFORMATION16 | Developer descriptive flexfield column. |
| CTY_INFORMATION12 | Developer descriptive flexfield column. |
| CTY_INFORMATION18 | Developer descriptive flexfield column. |
| CTY_INFORMATION19 | Developer descriptive flexfield column. |
| CTY_INFORMATION20 | Developer descriptive flexfield column. |
| CTY_INFORMATION17 | Developer descriptive flexfield column. |
| CTY_INFORMATION21 | Developer descriptive flexfield column. |
| Payroll - PER_US_INVAL_ADDRESSES | Temporary table used to hold invalid addresses. |
|---|---|
| Column Name | Descritpion |
| ADDRESS_ID | Foreign key to PER_ADDRESSES. |
| Payroll - PER_US_INVAL_LOCATIONS | Temporary table used to hold invalid location addresses. |
|---|---|
| Column Name | Descritpion |
| LOCATION_ID | Foreign key to HR_LOCATIONS. |
| Payroll - PAY_US_MODIFIED_GEOCODES | US cities and their VERTEX geocodes, used for showing modified geocodes. |
|---|---|
| Column Name | Descritpion |
| CITY_NAME | City name. |
| PATCH_NAME | Patch name |
| NEW_COUNTY_CODE | Geocode New County Code |
| STATE_CODE | Foreign key to PAY_US_COUNTIES. |
| COUNTY_CODE | Foreign key to PAY_US_COUNTIES. |
| NEW_CITY_CODE | What the CITY_CODE has been modified to. |
| OLD_CITY_CODE | What the CITY_CODE used to be. |
| PRIMARY_FLAG | Used when the geocode represents more than one city. |
| PROCESS_TYPE | Used to explain why geocode has changed. |
| Payroll - PAY_US_STATE_TAX_INFO_F | Holds the state tax information. |
|---|---|
| Column Name | Descritpion |
| STATE_TAX_INFO_ID | System-generated primary key column. |
| SHI_EE_WAGE_LIMIT | SHI EE wage base limit |
| STA_INFORMATION30 | Developer descriptive flexfield column. |
| SHI_ER_WAGE_LIMIT | SHI EE wage base limit |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| STATE_CODE | State Geocode |
| EFFECTIVE_START_DATE | Effective start date. |
| EFFECTIVE_END_DATE | Effective end date. |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure definition column. |
| STA_ATTRIBUTE1 | Descriptive flexfield column. |
| STA_ATTRIBUTE2 | Descriptive flexfield column. |
| STA_ATTRIBUTE3 | Descriptive flexfield column. |
| STA_ATTRIBUTE4 | Descriptive flexfield column. |
| STA_ATTRIBUTE5 | Descriptive flexfield column. |
| STA_ATTRIBUTE6 | Descriptive flexfield column. |
| STA_ATTRIBUTE7 | Descriptive flexfield column. |
| SIT_EXISTS | State Income tax exists for state (Y/N) |
| STA_ATTRIBUTE8 | Descriptive flexfield column. |
| STA_ATTRIBUTE9 | Descriptive flexfield column. |
| STA_ATTRIBUTE10 | Descriptive flexfield column. |
| STA_ATTRIBUTE11 | Descriptive flexfield column. |
| STA_ATTRIBUTE12 | Descriptive flexfield column. |
| STA_ATTRIBUTE13 | Descriptive flexfield column. |
| STA_ATTRIBUTE14 | Descriptive flexfield column. |
| STA_ATTRIBUTE15 | Descriptive flexfield column. |
| SUI_EE_WAGE_LIMIT | SUI EE wage base limit |
| STA_ATTRIBUTE16 | Descriptive flexfield column. |
| STA_ATTRIBUTE17 | Descriptive flexfield column. |
| STA_ATTRIBUTE18 | Descriptive flexfield column. |
| STA_ATTRIBUTE19 | Descriptive flexfield column. |
| STA_ATTRIBUTE20 | Descriptive flexfield column. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| SUI_ER_WAGE_LIMIT | SUI ER wage base limit |
| STA_INFORMATION_CATEGORY | Developer descriptive flexfield column. |
| STA_INFORMATION1 | Developer descriptive flexfield column. |
| STA_INFORMATION2 | Developer descriptive flexfield column. |
| STA_INFORMATION3 | Developer descriptive flexfield column. |
| STA_INFORMATION4 | Developer descriptive flexfield column. |
| STA_INFORMATION5 | Developer descriptive flexfield column. |
| STA_INFORMATION6 | Developer descriptive flexfield column. |
| STA_INFORMATION7 | Developer descriptive flexfield column. |
| STA_INFORMATION8 | Developer descriptive flexfield column. |
| STA_INFORMATION9 | Developer descriptive flexfield column. |
| SDI_EE_WAGE_LIMIT | SDI EE wage base limit |
| STA_INFORMATION10 | Developer descriptive flexfield column. |
| STA_INFORMATION11 | Developer descriptive flexfield column. |
| STA_INFORMATION12 | Developer descriptive flexfield column. |
| STA_INFORMATION13 | Developer descriptive flexfield column. |
| STA_INFORMATION14 | Developer descriptive flexfield column. |
| STA_INFORMATION15 | Developer descriptive flexfield column. |
| STA_INFORMATION16 | Developer descriptive flexfield column. |
| STA_INFORMATION17 | Developer descriptive flexfield column. |
| STA_INFORMATION18 | Developer descriptive flexfield column. |
| STA_INFORMATION19 | Developer descriptive flexfield column. |
| SDI_ER_WAGE_LIMIT | SDI ER wage base limit |
| STA_INFORMATION20 | Developer descriptive flexfield column. |
| STA_INFORMATION21 | Developer descriptive flexfield column. |
| STA_INFORMATION22 | Developer descriptive flexfield column. |
| STA_INFORMATION23 | Developer descriptive flexfield column. |
| STA_INFORMATION24 | Developer descriptive flexfield column. |
| STA_INFORMATION25 | Developer descriptive flexfield column. |
| STA_INFORMATION26 | Developer descriptive flexfield column. |
| STA_INFORMATION27 | Developer descriptive flexfield column. |
| STA_INFORMATION28 | Developer descriptive flexfield column. |
| STA_INFORMATION29 | Developer descriptive flexfield column. |
| Payroll - PAY_US_FEDERAL_TAX_INFO_F | Holds federal tax information. |
|---|---|
| Column Name | Descritpion |
| FEDERAL_TAX_INFO_ID | System-generated primary key column. |
| SS_ER_RATE | SS ER rate |
| FED_INFORMATION28 | Developer descriptive flexfield column. |
| FED_INFORMATION29 | Developer descriptive flexfield column. |
| FED_INFORMATION30 | Developer descriptive flexfield column. |
| MEDI_EE_RATE | MEDI EE rate |
| MEDI_ER_RATE | MEDI ER rate |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| EFFECTIVE_START_DATE | Effective start date. |
| EFFECTIVE_END_DATE | Effective end date. |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure definition column. |
| FED_ATTRIBUTE1 | Descriptive flexfield column. |
| FED_ATTRIBUTE2 | Descriptive flexfield column. |
| FED_ATTRIBUTE3 | Descriptive flexfield column. |
| FED_ATTRIBUTE4 | Descriptive flexfield column. |
| FED_ATTRIBUTE5 | Descriptive flexfield column. |
| FUTA_WAGE_LIMIT | FUTA ER wage base limit |
| FED_ATTRIBUTE6 | Descriptive flexfield column. |
| FED_ATTRIBUTE7 | Descriptive flexfield column. |
| FED_ATTRIBUTE8 | Descriptive flexfield column. |
| FED_ATTRIBUTE9 | Descriptive flexfield column. |
| FED_ATTRIBUTE10 | Descriptive flexfield column. |
| FED_ATTRIBUTE11 | Descriptive flexfield column. |
| FED_ATTRIBUTE12 | Descriptive flexfield column. |
| FED_ATTRIBUTE13 | Descriptive flexfield column. |
| FUTA_RATE | FUTA ER rate |
| FED_ATTRIBUTE14 | Descriptive flexfield column. |
| FED_ATTRIBUTE15 | Descriptive flexfield column. |
| FED_ATTRIBUTE16 | Descriptive flexfield column. |
| FED_ATTRIBUTE17 | Descriptive flexfield column. |
| FED_ATTRIBUTE18 | Descriptive flexfield column. |
| FED_ATTRIBUTE19 | Descriptive flexfield column. |
| FED_ATTRIBUTE20 | Descriptive flexfield column. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| SS_EE_WAGE_LIMIT | SS EE wage base limit |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| FED_INFORMATION_CATEGORY | Developer descriptive flexfield column. |
| FED_INFORMATION1 | Developer descriptive flexfield column. |
| FED_INFORMATION2 | Developer descriptive flexfield column. |
| FED_INFORMATION3 | Developer descriptive flexfield column. |
| FED_INFORMATION4 | Developer descriptive flexfield column. |
| FED_INFORMATION5 | Developer descriptive flexfield column. |
| FED_INFORMATION6 | Developer descriptive flexfield column. |
| FED_INFORMATION7 | Developer descriptive flexfield column. |
| SS_EE_RATE | SS EE rate |
| FED_INFORMATION8 | Developer descriptive flexfield column. |
| FED_INFORMATION9 | Developer descriptive flexfield column. |
| FED_INFORMATION10 | Developer descriptive flexfield column. |
| FED_INFORMATION11 | Developer descriptive flexfield column. |
| FED_INFORMATION12 | Developer descriptive flexfield column. |
| FED_INFORMATION13 | Developer descriptive flexfield column. |
| FED_INFORMATION14 | Developer descriptive flexfield column. |
| FED_INFORMATION15 | Developer descriptive flexfield column. |
| FED_INFORMATION16 | Developer descriptive flexfield column. |
| FED_INFORMATION17 | Developer descriptive flexfield column. |
| SS_ER_WAGE_LIMIT | SS ER wage base limit |
| FED_INFORMATION18 | Developer descriptive flexfield column. |
| FED_INFORMATION19 | Developer descriptive flexfield column. |
| FED_INFORMATION20 | Developer descriptive flexfield column. |
| FED_INFORMATION21 | Developer descriptive flexfield column. |
| FED_INFORMATION22 | Developer descriptive flexfield column. |
| FED_INFORMATION23 | Developer descriptive flexfield column. |
| FED_INFORMATION24 | Developer descriptive flexfield column. |
| FED_INFORMATION25 | Developer descriptive flexfield column. |
| FED_INFORMATION26 | Developer descriptive flexfield column. |
| FED_INFORMATION27 | Developer descriptive flexfield column. |
| Payroll - PAY_US_COUNTY_TAX_INFO_F | Holds county tax information. |
|---|---|
| Column Name | Descritpion |
| COUNTY_TAX_INFO_ID | System-generated primary key column. |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| CNTY_INFORMATION_CATEGORY | Developer descriptive flexfield |
| CNTY_INFORMATION1 | Developer descriptive flexfield |
| CNTY_INFORMATION2 | Developer descriptive flexfield |
| CNTY_INFORMATION3 | Developer descriptive flexfield |
| CNTY_INFORMATION4 | Developer descriptive flexfield |
| CNTY_INFORMATION5 | Developer descriptive flexfield |
| CNTY_INFORMATION6 | Developer descriptive flexfield |
| CNTY_INFORMATION7 | Developer descriptive flexfield |
| CNTY_INFORMATION8 | Developer descriptive flexfield |
| CNTY_INFORMATION9 | Developer descriptive flexfield |
| CNTY_INFORMATION10 | Developer descriptive flexfield |
| CNTY_INFORMATION11 | Developer descriptive flexfield |
| CNTY_INFORMATION12 | Developer descriptive flexfield |
| EFFECTIVE_START_DATE | Effective start date. |
| CNTY_INFORMATION13 | Developer descriptive flexfield |
| CNTY_INFORMATION14 | Developer descriptive flexfield |
| CNTY_INFORMATION15 | Developer descriptive flexfield |
| CNTY_INFORMATION16 | Developer descriptive flexfield |
| CNTY_INFORMATION17 | Developer descriptive flexfield |
| CNTY_INFORMATION18 | Developer descriptive flexfield |
| CNTY_INFORMATION19 | Developer descriptive flexfield |
| CNTY_INFORMATION20 | Developer descriptive flexfield |
| CNTY_INFORMATION21 | Developer descriptive flexfield |
| CNTY_INFORMATION22 | Developer descriptive flexfield |
| CNTY_INFORMATION23 | Developer descriptive flexfield |
| CNTY_INFORMATION24 | Developer descriptive flexfield |
| CNTY_INFORMATION25 | Developer descriptive flexfield |
| CNTY_INFORMATION26 | Developer descriptive flexfield |
| CNTY_INFORMATION27 | Developer descriptive flexfield |
| CNTY_INFORMATION28 | Developer descriptive flexfield |
| CNTY_INFORMATION29 | Developer descriptive flexfield |
| CNTY_INFORMATION30 | Developer descriptive flexfield |
| EFFECTIVE_END_DATE | Effective end date. |
| JURISDICTION_CODE | Full Jurisdiction geocode |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure definition column. |
| CNTY_ATTRIBUTE1 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE2 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE3 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE4 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE5 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE6 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE7 | Descriptive flexfield column. |
| COUNTY_TAX | County tax exists for county (Y/N) |
| CNTY_ATTRIBUTE8 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE9 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE10 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE11 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE12 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE13 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE14 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE15 | Descriptive flexfield column. |
| HEAD_TAX | Head Tax exists for county (Y/N) |
| CNTY_ATTRIBUTE16 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE17 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE18 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE19 | Descriptive flexfield column. |
| CNTY_ATTRIBUTE20 | Descriptive flexfield column. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| SCHOOL_TAX | School tax exists for county (Y/N) |
| Payroll - PAY_WCI_ACCOUNTS | Workers Compensation Accounts table. |
|---|---|
| Column Name | Descritpion |
| BUSINESS_GROUP_ID | Foreign key to HR_ORGANIZATION_UNITS. |
| CARRIER_ID | Foreign Key to HR_ORGANIZATION_UNITS, this is the Workers Compensation Board. |
| LOCATION_ID | Foreign Key to HR_LOCATIONS_ALL. |
| NAME | The user specified name for the Workers Compensation account. |
| ACCOUNT_NUMBER | Company specific Workers Compensation account number assigned by the Workers Compensation Board. |
| COMMENTS | General remark. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| ACCOUNT_ID | System generated primary key for Workers Compensation Accounts |
| CREATION_DATE | Standard who column - date when this row was created. |
| OBJECT_VERSION_NUMBER | System-generated version of row. Increments by one with each update. |
| Payroll - PAY_WCI_RATES | Workers Compensation rates table. NB. This table is currently used for Canadian workers compensation, but is designed to be used globally. |
|---|---|
| Column Name | Descritpion |
| BUSINESS_GROUP_ID | System generated foreign key to HR_ORGANIZATION_UNITS. |
| ACCOUNT_ID | Foreign Key to PAY_WCI_ACCOUNTS |
| CODE | Workers Compensation code. This code is defined by the Workers Compensation Board and applied to specific Jobs. |
| RATE | Rate for the specific Workers Compensation code. The rate is supplied by the Workers Compensation Board. |
| DESCRIPTION | User entered description of the Workers Compensation code. |
| COMMENTS | General remark. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| OBJECT_VERSION_NUMBER | System-generated version of row. Increments by one with each update. |
| RATE_ID | System generated primary key. |
| Payroll - PAY_WCI_OCCUPATIONS | Workers Compensation occupations table. |
|---|---|
| Column Name | Descritpion |
| BUSINESS_GROUP_ID | Foreign key to HR_ORGANIZATION_UNITS. |
| RATE_ID | Foreign key to PAY_WCI_RATES. |
| JOB_ID | Foreign key to PER_JOBS. |
| COMMENTS | General remark. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| OBJECT_VERSION_NUMBER | System-generated version of row. Increments by one with each update. |
| OCCUPATION_ID | System generated primary key. |
| Payroll - PAY_US_GEO_UPDATE | To keep track of changes made to the user data by the geocode patch. |
|---|---|
| Column Name | Descritpion |
| ID | Id from pay_patch_status |
| PROCESS_MODE | Mode in which the patch was run. Can be 'DEBUG' or 'UPGRADE'. |
| STATUS | For future use. |
| DESCRIPTION | For future use |
| ASSIGNMENT_ID | Assignment id from per_all_assignments_f |
| PERSON_ID | person_id from per_all_people_f |
| TABLE_NAME | Name of the table for which the data has been modified. |
| TABLE_VALUE_ID | Unique identifier for the table referenced in the table_name column |
| OLD_JURI_CODE | Jurisdiction code before the patch was applied. |
| NEW_JURI_CODE | The modified jurisdiction code. |
| PROCESS_TYPE | The type of geocode change. |
| PROCESS_DATE | Date on which the patch was applied. |
| Payroll - PAY_US_RPT_TOTALS | A temporary table to be used in Payroll and Paper W2 Reports. |
|---|---|
| Column Name | Descritpion |
| BUSINESS_GROUP_ID | |
| VALUE9 | |
| VALUE10 | |
| VALUE11 | |
| VALUE12 | |
| VALUE13 | |
| VALUE14 | |
| VALUE15 | |
| VALUE16 | |
| VALUE17 | |
| VALUE18 | |
| TAX_UNIT_ID | |
| VALUE19 | |
| VALUE20 | |
| VALUE21 | |
| VALUE22 | |
| VALUE23 | |
| VALUE24 | |
| VALUE25 | |
| VALUE26 | |
| VALUE27 | |
| VALUE28 | |
| GRE_NAME | |
| VALUE29 | |
| VALUE30 | |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ORGANIZATION_ID | |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | |
| ATTRIBUTE17 | |
| ATTRIBUTE18 | |
| ORGANIZATION_NAME | |
| ATTRIBUTE19 | |
| ATTRIBUTE20 | |
| ATTRIBUTE21 | |
| ATTRIBUTE22 | |
| ATTRIBUTE23 | |
| ATTRIBUTE24 | |
| ATTRIBUTE25 | |
| ATTRIBUTE26 | |
| ATTRIBUTE27 | |
| ATTRIBUTE28 | |
| LOCATION_ID | |
| ATTRIBUTE29 | |
| ATTRIBUTE30 | |
| ATTRIBUTE31 | |
| ATTRIBUTE32 | |
| ATTRIBUTE33 | |
| ATTRIBUTE34 | |
| ATTRIBUTE35 | |
| ATTRIBUTE36 | |
| ATTRIBUTE37 | |
| ATTRIBUTE38 | |
| LOCATION_NAME | |
| ATTRIBUTE39 | |
| ATTRIBUTE40 | |
| ATTRIBUTE41 | |
| ATTRIBUTE42 | |
| ATTRIBUTE43 | |
| ATTRIBUTE44 | |
| ATTRIBUTE45 | |
| STATE_CODE | |
| SESSION_ID | |
| STATE_ABBREV | |
| STATE_NAME | |
| VALUE1 | |
| VALUE2 | |
| VALUE3 | |
| VALUE4 | |
| VALUE5 | |
| VALUE6 | |
| VALUE7 | |
| VALUE8 |
| Payroll - PER_PAY_PROPOSAL_COMPONENT_EFC | |
|---|---|
| Column Name | Descritpion |
| COMPONENT_ID | |
| EFC_ACTION_ID | |
| CHANGE_AMOUNT_N | |
| INPUT_CURRENCY_CODE |
| Payroll - PAY_ZA_ACB_USER_GEN_NOS | PAY_ZA_ACB_USER_GEN_NOS holds the ACB generation number information needed when submitting magnetic tapes to ACB. |
|---|---|
| Column Name | Descritpion |
| PAYROLL_ACTION_ID | Payroll Action ID |
| USER_CODE | ACB User Code (Issued by ACB) |
| GEN_NUMBER | ACB Generation Numbers |
| Payroll - PAY_ZA_IRP5_BAL_CODES | Table holds codes for IRP5 balances |
|---|---|
| Column Name | Descritpion |
| BALANCE_TYPE_ID | Balance Type ID |
| BALANCE_NAME | The description that shows on the tax certificates |
| CODE | IRP5 code supplied by SARS |
| USER_NAME | The name of the associated database item |
| FULL_BALANCE_NAME | Name of balance |
| BALANCE_SEQUENCE | Balance sequence |
| Payroll - PAY_ZA_TAX_REGISTERS | PAY_ZA_TAX_REGISTERS is used for the South African Tax Register Report. |
|---|---|
| Column Name | Descritpion |
| TAX_REGISTER_ID | Tax Register ID |
| DAYS_WORKED | Days Worked |
| ASSIGNMENT_ID | Assignment ID |
| ASSIGNMENT_ACTION_ID | Assignment action ID |
| ASSIGNMENT_NUMBER | Assignment number |
| ASSIGNMENT_START_DATE | Assignment start date |
| ASSIGNMENT_END_DATE | Assignment end date |
| BAL_NAME | Balance Name |
| BAL_CODE | Balance Code |
| TOT_PTD | Total PTD amount |
| TOT_MTD | Total MTD amount |
| FULL_NAME | Full name |
| TOT_YTD | Total YTD amount |
| FIRST_NAME | First name |
| LAST_NAME | Last name |
| MIDDLE_NAMES | Middle names |
| HIRE_DATE | Hire date |
| REG_PAYMENT_DATE | Regular Payment Date |
| END_DATE | End date |
| TERMINATION_DATE | Termination date |
| TIME_PERIOD_ID | Payroll Period ID |
| LOCATION_CODE | Location Code |
| EMPLOYEE_NUMBER | Employee Number |
| PERSON_ID | Person ID |
| DATE_OF_BIRTH | Date of birth |
| AGE | Age |
| TAX_REFERENCE_NO | Tax reference number |
| CMPY_TAX_REFERENCE_NO | Cmpy Tax Reference No |
| TAX_STATUS | Tax Status |
| TAX_DIRECTIVE_VALUE | Tax Directive Value |
| Payroll - PAY_ZA_TEMP_BRANCH_DETAILS | PAY_ZA_TEMP_BRANCH_DETAILS is a temporary table that holds Bank and Branch information used to verify Bank account numbers, used in the population of PAY_ZA_BRANCH_CDV_DETAILS. |
|---|---|
| Column Name | Descritpion |
| RECORD_IND | Type of record |
| STREET_ADDRESS_LINE_2 | Address Details |
| PO_BOX_NUMBER | Address Details |
| PO_BOX_POST_OFFICE | Address Details |
| POSTAL_CODE | Address Details |
| ACCOUNT_TYPE_1 | Type of account |
| MODULUS_1 | Modulus factor |
| FUDGE_FACTOR_1 | Factor added to check sum calculation |
| CDV_WEIGHTINGS_1 | Validation weighting |
| EXCEPTION_CODE_1 | Additional Validation |
| ACCOUNT_IND_1 | Account Indicator |
| BRANCH_CODE | Branch Code |
| ACCOUNT_TYPE_2 | Type of account |
| MODULUS_2 | Modulus factor |
| FUDGE_FACTOR_2 | Factor added to check sum calculation |
| CDV_WEIGHTINGS_2 | Validation weighting |
| EXCEPTION_CODE_2 | Additional Validation |
| ACCOUNT_IND_2 | Account Indicator |
| ACCOUNT_TYPE_3 | Type of account |
| MODULUS_3 | Modulus factor |
| FUDGE_FACTOR_3 | Factor added to check sum calculation |
| CDV_WEIGHTINGS_3 | Validation weighting |
| SSV_ALLOWED | Sub-service allowed indicator |
| EXCEPTION_CODE_3 | Additional Validation |
| ACCOUNT_IND_3 | Account Indicator |
| ACCOUNT_TYPE_4 | Type of account |
| MODULUS_4 | Modulus factor |
| FUDGE_FACTOR_4 | Factor added to check sum calculation |
| CDV_WEIGHTINGS_4 | Validation weighting |
| EXCEPTION_CODE_4 | Additional Validation |
| ACCOUNT_IND_4 | Account Indicator |
| ACCOUNT_TYPE_5 | Type of account |
| MODULUS_5 | Modulus factor |
| ONE_DAY_SS | One day sub-service |
| FUDGE_FACTOR_5 | Factor added to check sum calculation |
| CDV_WEIGHTINGS_5 | Validation weighting |
| EXCEPTION_CODE_5 | Additional Validation |
| ACCOUNT_IND_5 | Account Indicator |
| ACCOUNT_TYPE_6 | Type of account |
| MODULUS_6 | Modulus factor |
| FUDGE_FACTOR_6 | Factor added to check sum calculation |
| CDV_WEIGHTINGS_6 | Validation weighting |
| EXCEPTION_CODE_6 | Additional Validation |
| ACCOUNT_IND_6 | Account Indicator |
| TWO_DAY_SS | Two day sub-service |
| ACCOUNT_TYPE_7 | Type of account |
| MODULUS_7 | Modulus factor |
| FUDGE_FACTOR_7 | Factor added to check sum calculation |
| CDV_WEIGHTINGS_7 | Validation weighting |
| EXCEPTION_CODE_7 | Additional Validation |
| ACCOUNT_IND_7 | Account Indicator |
| ACCOUNT_TYPE_8 | Type of account |
| MODULUS_8 | Modulus factor |
| FUDGE_FACTOR_8 | Factor added to check sum calculation |
| CDV_WEIGHTINGS_8 | Validation weighting |
| FIVE_DAY_SS | Five day sub-service |
| EXCEPTION_CODE_8 | Additional Validation |
| ACCOUNT_IND_8 | Account Indicator |
| ACCOUNT_TYPE_9 | Type of account |
| MODULUS_9 | Modulus factor |
| FUDGE_FACTOR_9 | Factor added to check sum calculation |
| CDV_WEIGHTINGS_9 | Validation weighting |
| EXCEPTION_CODE_9 | Additional Validation |
| ACCOUNT_IND_9 | Account Indicator |
| TELEPHONE_NUMBER | Contact Details |
| DIALING_CODE | Contact Details |
| STREAM_CODE | Stream Code |
| TELEX1 | Contact Details |
| TELEX2 | Contact Details |
| DELETION_DATE | Deletion Date of Information |
| BRANCH_NAME | Branch Name |
| STREET_ADDRESS_LINE_1 | Address Details |
| Payroll - PAY_ZA_TYS_PROCESSES | PAY_ZA_TYS_PROCESSES stored information about each Tax Year Start Process that was run to ensure that the process will not be run for the same payroll and tax year, and to ensure that a rollback on the process will not occur if the specific |
|---|---|
| Column Name | Descritpion |
| TYSP_ID | Tax year start process ID |
| PAYROLL_ID | Payroll ID |
| CONSOLIDATION_SET_ID | Consolidation Set ID |
| TAX_YEAR | Current Tax Year |
| Payroll - PAY_ZA_TAX_TRACES | PAY_ZA_TAX_TRACES holds tax trace data calculated during the payroll run. Only the most recent run's data will be stored. |
|---|---|
| Column Name | Descritpion |
| ASG_ACT_ID | Assignment Action ID |
| TXPERCVAL | Set to the Percentage used in the tax calculation for assignments with Tax Status: Directive Percentage, Close Corporation and Temporary Worker / Student. |
| ANNPYMERN | Annual Payments plus AnnBonErn |
| TXBANNPYMINC | The taxable value used to calculate the tax liability on AnnPymErn |
| LIBFYAP | Calculated Liability for the tax year for Annual Payments |
| TX_ON_AP_YTD | Balance Value: Tax on Annual Payments YTD |
| TX_ON_AP_PTD | Balance Value: Tax on Annual Payments PTD |
| LIBFPAP | Calculated Liability that will be deducted in the current payroll run. |
| PBLOFFYTD | The sum total of the YTD dimension value of the balances constituting Public Office Allowance |
| PBLOFFPTD | The sum total of the PTD dimension value of the balances constituting Public Office Allowance |
| PBLOFFERN | The annualised Public Office Allowance value |
| LIBFYPO | Calculated Liability for the tax year for Public Office Allowance |
| ASG_STRT_DTE | Value of the Database Item: ASG_START_DATE |
| TX_ON_PO_YTD | Balance Value: Tax on Public Office Allow YTD |
| TX_ON_PO_PTD | Balance Value: Tax on Public Office Allow PTD |
| LIBFPPO | Calculated Liability that will be deducted in the current payroll run |
| MSGTXSTATUS | No longer used |
| LIBWRN | Warning Message |
| PAYVALUE | Total Liability to be deducted |
| PAYEVAL | The value to Update the PAYE balance value |
| SITEVAL | The value to update the SITE balance value |
| ANNARRPENFND | Annual Arrear Pension Fund |
| ANNARRPENFNDABM | Annual Arrear Pension Fund Abatement |
| ZA_ACT_END_DTE | Value of the Database Item: ZA_ACTUAL_END_DATE |
| ANNRETANU | Annual Retirement Annuity |
| ANNNRFICON | Annual NRFI Income |
| ANNRETANUMAX | Annual Retirement Annuity Maximum |
| ANNRETANUABM | Annual Retirement Annuity Abatement |
| ANNARRRETANU | Annual Arrear Retirement Annuity |
| ANNARRRETANUABM | Annual Arrear Retirement Annuity Abatement |
| ZA_CUR_PRD_STRT_DTE | Value of the Database Item: ZA_CURRENT_PERIOD_END_DATE |
| ZA_CUR_PRD_END_DTE | Value of the Database Item: ZA_CURRENT_PERIOD_START_DATE |
| ZA_TX_YR_STRT | Value of the Database Item: ZA_TAX_YEAR_START |
| ZA_TX_YR_END | Value of the Database Item: ZA_TAX_YEAR_END |
| SES_DTE | Value of the Database Item: SESSION_DATE |
| PRDFACTOR | Period Factor |
| POSFACTOR | Possible Period Factor |
| ASG_ID | Assignment ID |
| SITFACTOR | Site Factor. Days in the Year divided by Days Worked. |
| ZA_PAY_PRDS_LFT | Value of the Database Item: ZA_PAY_PERIODS_LEFT |
| ZA_PAY_PRDS_PER_YR | Value of the Database Item: ZA_PAY_PERIODS_PER_YEAR |
| ZA_DYS_IN_YR | Value of the Database Item: ZA_DAYS_IN_YEAR |
| SEA_WRK_DYS_WRK | ZA_Tax Element Input Value: SEASONAL_WORKERS_DAYS_WORKED |
| ARR_PF_FRQ | ZA_Tax Element Input Value: ARREAR_PENSION_FREQUENCY |
| ARR_RA_FRQ | ZA_Tax Element Input Value: ARREAR_RA_FREQUENCY |
| BP_TX_RCV | ZA_Tax Element Input Value: BONUS_PROVISION_TAX_RECOVERY |
| RA_FRQ | ZA_Tax Element Input Value: RETIREMENT_ANNUITY_FREQUENCY |
| TXBINCPTD | Period Type Income PTD Balances that are referenced in the Tax calculation. |
| PRL_ACT_ID | Payroll Action ID |
| BSEERN | Value calculated to be used as a base for tax calculation purposes. |
| TXBBSEINC | Taxable Base Income |
| TOTLIBBSE | Tax liability on Taxable Base Income |
| TXBINCYTD | Period type TAX_ or CAL_YTD income balance values |
| PERTXBINC | No longer used. |
| PERPENFND | Annualised Period Pension Fund |
| PERRFICON | Annualised Total RFIable Income |
| PERRFITXB | No longer used. |
| PERPENFNDMAX | Calculated Maximum Pension Fund Abatement for Period Type Income. |
| PERPENFNDABM | Calculated Pension Fund Abatement value for Period Type Income |
| PRL_ID | Payroll ID |
| ANNTXBINC | No longer used. |
| ANNPENFND | PerPenFnd plus Annual Pension Fund Contributions. |
| ANNRFICON | PerRfiCon plus Total Rfiable Annual Income |
| ANNRFITXB | No longer used. |
| ANNPENFNDMAX | Calculated Maximum Pension Fund Abatement for Annual Type Income. |
| ANNPENFNDABM | Calculated Pension Fund Abatement value for Annual Type Income. |
| ARRPENFND | Annualised contribution value of Arrear Pension plus any excess carried over taking into account the contribution frequency. |
| ARRPENFNDABM | Calculated Arrear Pension Fund Abatement. |
| RETANU | Annualised retirement annuity contribution taking into account the contribution frequency. |
| NRFICON | Annualised NRFI contribution value. If there are no Pension Fund contributions everything is NRFI. |
| TX_STA | Tax Status for the run |
| RETANUMAX | Calculated Maximum Retirement Annuity Value. |
| RETANUABM | Calculated Retirement Annuity Abatement. |
| ARRRETANU | Annualised contribution value of Arrear Retirement Annuity plus any excess carried over taking into account the contribution frequency. |
| ARRRETANUABM | Calculated Arrear Retirement Annuity Abatement. |
| REBATE | Rebate Figure. |
| THRESHOLD | Tax Threshold Figure. |
| MEDAIDABM | Calculated Medical Aid Abatement. |
| PERTOTABM | Total Abatement Figure for Period Type Income. |
| ANNTOTABM | Total Abatement Figure for Annual Type Income. |
| NORINCYTD | The sum total of the YTD dimension value of the balances constituting Normal Income. |
| PER_AGE | Value of the PER_AGE Database Item |
| NORINCPTD | The sum total of the PTD dimension value of the balances constituting Normal Income. |
| NORERN | The annualised Normal Income value. |
| TXBNORINC | The taxable value used to calculate the tax liability on Normal Income. |
| LIBFYNI | Calculated Liability for the tax year for Normal Income. |
| TX_ON_NI_YTD | Balance Value: Tax on Normal Income YTD |
| TX_ON_NI_PTD | Balance Value: Tax on Normal Income PTD |
| LIBFPNI | Calculated Liability that will be deducted in the current payroll run. |
| FRNBENYTD | The sum total of the YTD dimension value of the balances constituting Fringe Benefits. |
| FRNBENPTD | The sum total of the PTD dimension value of the balances constituting Fringe Benefits. |
| FRNBENERN | The annualised Fringe Benefits value plus NorErn. |
| CALTYP | Indicates the last calculation that was done, eg. NorCalc is the Normal Calculation was performed |
| TXBFRNINC | The taxable value used to calculate the tax liability on FrnBenErn |
| LIBFYFB | Calculated Liability for the tax year for Fringe Benefits |
| TX_ON_FB_YTD | Balance Value: Tax on Fringe Benefits YTD |
| TX_ON_FB_PTD | Balance Value: Tax on Fringe Benefits PTD |
| LIBFPFB | Calculated Liability that will be deducted in the current payroll run |
| TRVALLYTD | The sum total of the YTD dimension value of the balances constituting Travel Allowance |
| TRVALLPTD | The sum total of the PTD dimension value of the balances constituting Travel Allowance |
| TRVALLERN | The annualised Travel Allowance value plus FrnBenErn |
| TXBTRVINC | The taxable value used to calculate the tax liability on TrvAllErn |
| LIBFYTA | Calculated Liability for the tax year for Travel Allowance |
| TX_DIR_VAL | Value of the Input Value: TAX DIRECTIVE VALUE |
| TX_ON_TA_YTD | Balance Value: Tax on Car Allowance YTD |
| TX_ON_TA_PTD | Balance Value: Tax on Car Allowance PTD |
| LIBFPTA | Calculated Liability that will be deducted in the current payroll run |
| BONPROYTD | The sum total of the YTD dimension value of the balances constituting Bonus Provision |
| BONPROPTD | The sum total of the PTD dimension value of the balances constituting Bonus Provision |
| BONPROERN | The annualised Bonus Provision value plus TrvAllErn |
| TXBBONPROINC | The taxable value used to calculate the tax liability on BonProErn. |
| LIBFYBP | Calculated Liability for the tax year for Bonus Provision |
| TX_ON_BP_YTD | Balance Value: Tax on Bonus Provision YTD |
| TX_ON_BP_PTD | Balance Balue: Tax on Bonus Provision PTD |
| IT3IND | Indicator used in the IT3A report. Will be 1 if the assignment falls under the Tax threshold figure and 0 (zero) if over the threshold figure. |
| LIBFPBP | Calculated Liability that will be deducted in the current payroll run |
| ANNBONYTD | The sum total of the YTD dimension value of the balances constituting Annual Bonus |
| ANNBONERN | Annual Bonus YTD plus TrvAllErn |
| TXBANNBONINC | The taxable value used to calculate the tax liability on AnnBonErn |
| LIBFYAB | Calculated Liability for the tax year for Annual Bonus |
| TX_ON_AB_YTD | Balance Value: Tax on Annual Bonus YTD |
| TX_ON_AB_PTD | Balance Value: Tax on Annual Bonus PTD |
| LIBFPAB | Calculated Liability that will be deducted in the current payroll run |
| ANNPYMYTD | The sum total of the YTD dimension value of the balances constituting Annual Payments |
| ANNPYMPTD | The sum total of the PTD dimension value of the balances constituting Annual Payments |
| Payroll - PAY_ZA_TAXREG_BAL_TEMP | Table holds balance types for specific assignments |
|---|---|
| Column Name | Descritpion |
| BALANCE_TYPE_ID | Tax Balance Type ID |
| ASSIGNMENT_ID | Assignment ID |
| Payroll - PAY_ZA_BRANCH_CDV_DETAILS | PAY_ZA_BRANCH_CDV_DETAILS stores Bank and Branch information used to verify Bank account numbers. |
|---|---|
| Column Name | Descritpion |
| BRANCH_CODE | Branch Code |
| STREET_ADDRESS_LINE_2 | Address Details |
| PO_BOX_NUMBER | Address Details |
| PO_BOX_POST_OFFICE | Address Details |
| POSTAL_CODE | Address Details |
| TELEPHONE_NUMBER | Contact Details |
| DIALING_CODE | Contact Details |
| TELEX1 | Contact Details |
| TELEX2 | Contact Details |
| DELETION_DATE | Deletion Date of Information |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| SSV_ALLOWED | Sub-service allowed (Y/N) |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| ONE_DAY_SS | One day Sub-service |
| TWO_DAY_SS | Two day Sub-service |
| FIVE_DAY_SS | Five day Sub-service |
| STREAM_CODE | Stream Code |
| BANK_NAME | Bank Name |
| BRANCH_NAME | Branch Name |
| STREET_ADDRESS_LINE_1 | Address Details |
| Payroll - PAY_ZA_CDV_PARAMETERS | PAY_ZA_CDV_PARAMETERS holds information needed to perform the CDV on bank account numbers. |
|---|---|
| Column Name | Descritpion |
| BRANCH_CODE | Branch Code |
| CDV_WEIGHTING6 | Validation weighting |
| CDV_WEIGHTING7 | Validation weighting |
| CDV_WEIGHTING8 | Validation weighting |
| CDV_WEIGHTING9 | Validation weighting |
| CDV_WEIGHTING10 | Validation weighting |
| CDV_WEIGHTING11 | Validation weighting |
| EXCEPTION_CODE | Additional validation |
| ACCOUNT_INDICATOR | Account indicator |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| ACCOUNT_TYPE | Type of account |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| MODULUS | Modulus factor |
| FUDGE_FACTOR | Factor added to check sum calculation |
| CDV_WEIGHTING1 | Validation weighting |
| CDV_WEIGHTING2 | Validation weighting |
| CDV_WEIGHTING3 | Validation weighting |
| CDV_WEIGHTING4 | Validation weighting |
| CDV_WEIGHTING5 | Validation weighting |
| Payroll - PAY_US_SCHOOL_DSTS_TAX_INFO_F | The Federal Liaison Services ( FLS ) agency codes have been mapped to the School District Jurisdiction Information Codes |
|---|---|
| Column Name | Descritpion |
| SCHOOL_TAX_INFO_ID | System-generated primary key column. |
| SCH_ATTRIBUTE3 | Descriptive flexfield column. |
| SCH_ATTRIBUTE4 | Descriptive flexfield column. |
| SCH_ATTRIBUTE5 | Descriptive flexfield column. |
| SCH_ATTRIBUTE6 | Descriptive flexfield column. |
| SCH_ATTRIBUTE7 | Descriptive flexfield column. |
| EFFECTIVE_START_DATE | Effective start date. |
| SCH_ATTRIBUTE8 | Descriptive flexfield column. |
| SCH_ATTRIBUTE9 | Descriptive flexfield column. |
| SCH_ATTRIBUTE10 | Descriptive flexfield column. |
| SCH_ATTRIBUTE11 | Descriptive flexfield column. |
| SCH_ATTRIBUTE12 | Descriptive flexfield column. |
| EFFECTIVE_END_DATE | Effective end date. |
| SCH_ATTRIBUTE13 | Descriptive flexfield column. |
| STATE_CODE | State geocode. |
| SCH_ATTRIBUTE14 | Descriptive flexfield column. |
| SCH_ATTRIBUTE16 | Descriptive flexfield column. |
| SCH_ATTRIBUTE17 | Descriptive flexfield column. |
| SCH_ATTRIBUTE18 | Descriptive flexfield column. |
| SCH_ATTRIBUTE19 | Descriptive flexfield column. |
| SCH_ATTRIBUTE20 | Descriptive flexfield column. |
| SCH_INFORMATION_CATEGORY | Developer descriptive flexfield structure definition column. |
| SCH_INFORMATION1 | Developer descriptive flexfield column. |
| SCH_INFORMATION2 | Developer descriptive flexfield column. |
| SCH_INFORMATION3 | Developer descriptive flexfield column. |
| SCHOOL_DSTS_CODE | School District geocode |
| SCH_INFORMATION4 | Developer descriptive flexfield column. |
| SCH_INFORMATION5 | Developer descriptive flexfield column. |
| SCH_INFORMATION6 | Developer descriptive flexfield column. |
| SCH_INFORMATION7 | Developer descriptive flexfield column. |
| SCH_INFORMATION8 | Developer descriptive flexfield column. |
| SCH_INFORMATION9 | Developer descriptive flexfield column. |
| SCH_INFORMATION10 | Developer descriptive flexfield column. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| JURISDICTION_CODE | Geocode of the jurisdiction |
| ATTRIBUTE_CATEGORY | Descriptive flexfield structure definition column. |
| SCH_ATTRIBUTE1 | Descriptive flexfield column. |
| SCH_ATTRIBUTE2 | Descriptive flexfield column. |
| Payroll - PAY_XLA_EVENTS | |
|---|---|
| Column Name | Descritpion |
| ASSIGNMENT_ACTION_ID | |
| ACCOUNTING_DATE | |
| EVENT_STATUS | |
| EVENT_ID |
No hay comentarios:
Publicar un comentario