Personality Knowledgebase 5.05
HighLine
Wiki
G’day (anonymous guest)
User Preferences
Log in
Register a new user!
For full search, hit enter...
Recent Searches
INF_CV_USPAYRULES
☰
Info
Version :
1
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.6 mins, 145 words
E
dit
More...
View Page Source
Show Reader View
Wiki Formatting
Main
This is version
1
2
3
4
5
6
7
8
. It is not the current version, and thus it cannot be edited.
Back to current version
Restore this version
Alias: IVPPRU
#
(INF_CV_USPAYRULES)
US Pay Rules
Table Columns
#
Column name
Data Type / Size
Domain
Mand.
Notes
ID
Number(10)
ID
ENTITY_CODE
Varchar2(16)
CODE
Y
PERSON_CODE
Varchar2(16)
CODE
Y
EMPLOYMENT_TYPE
Varchar2(30)
VARCHAR30
HIRE_DATE
Date()
DATE
COUNTRY_CODE
Varchar2(16)
CODE
STATE_PROVINCE_CODE
Varchar2(16)
CODE
GEO_CODE
Varchar2(16)
CODE
DESCRIPTION
Varchar2(50)
DESCRIPTION
EFFECTIVE
Date()
EFFECTIVE
Y
EXPIRY
Date()
EXPIRY
Y
CHANGE_CODE
Varchar2(16)
CODE
UFED_FILING_STATUS
Varchar2(30)
VARCHAR30
UFED_NUM_EXEMPTIONS
Number(5)
NUMBER5
UFED_ANN_EXEMPTION
Number(18)
AMT12V6
UFED_ADD_EXEMPTION
Number(18)
AMT12V6
UFED_ADD_TAX_PER_PERIOD
Number(18)
AMT12V6
UFED_TAX_AMOUNT
Number(18)
AMT12V6
UFED_TAX_PERCENT
Number(5)
PERCENT
UFED_TAX_METHOD
Varchar2(30)
VARCHAR30
UFED_SUPPL_TAX_METHOD
Varchar2(30)
VARCHAR30
UFED_FICA_METHOD
Varchar2(30)
VARCHAR30
UFED_MEDICARE_METHOD
Varchar2(30)
VARCHAR30
UFED_FUTA_METHOD
Varchar2(30)
VARCHAR30
UFED_EIC_METHOD
Varchar2(30)
VARCHAR30
UST_RECIPROCATION
Varchar2(30)
VARCHAR30
UST_FILING_STATUS
Varchar2(30)
VARCHAR30
UST_NUM_EXEMPTION_1
Number(5)
NUMBER5
UST_NUM_EXEMPTION_2
Number(5)
NUMBER5
UST_ANN_EXEMPTION
Number(18)
AMT12V6
UST_ADD_EXEMPTION
Number(18)
AMT12V6
UST_ADD_TAX_PER_PERIOD
Number(18)
AMT12V6
UST_ADD_TAX_RES
Varchar2(30)
VARCHAR30
UST_ADD_TAX_WORK
Varchar2(30)
VARCHAR30
UST_TAX_AMOUNT
Number(18)
AMT12V6
UST_TAX_PERCENT
Number(5)
PERCENT
UST_TAX_METHOD
Varchar2(30)
VARCHAR30
UST_SUPPL_TAX_METHOD
Varchar2(30)
VARCHAR30
UST_ALT_TAX_METHOD
Varchar2(30)
VARCHAR30
UST_SUI_EE_METHOD
Varchar2(30)
VARCHAR30
UST_SUI_ER_METHOD
Varchar2(30)
VARCHAR30
UST_SDI_EE_METHOD
Varchar2(30)
VARCHAR30
UST_SDI_ER_METHOD
Varchar2(30)
VARCHAR30
UST_WCB_METHOD
Varchar2(30)
VARCHAR30
ULOC_RECIPROCATION
Varchar2(30)
VARCHAR30
ULOC_FILING_STATUS
Varchar2(30)
VARCHAR30
ULOC_NUM_EXEMPTIONS
Number(5)
NUMBER5
ULOC_ANN_EXEMPTION
Number(18)
AMT12V6
ULOC_EXEMPTION_PERCENT
Number(5)
PERCENT
ULOC_ADD_TAX_PER_PERIOD
Number(18)
AMT12V6
ULOC_ADD_TAX_WORK
Varchar2(30)
VARCHAR30
ULOC_ADD_TAX_RES
Varchar2(30)
VARCHAR30
ULOC_TAX_AMOUNT
Number(18)
AMT12V6
ULOC_TAX_PERCENT_1
Number(5)
PERCENT
ULOC_TAX_PERCENT_2
Number(5)
PERCENT
ULOC_COUNTY_TAX_METHOD
Varchar2(30)
VARCHAR30
ULOC_CITY_TAX_METHOD
Varchar2(30)
VARCHAR30
ULOC_SCHOOL_TAX_METHOD
Varchar2(30)
VARCHAR30
ULOC_SCHOOL_TAX_AMOUNT
Number(18)
AMT12V6
ULOC_SCHOOL_TAX_PERCENT
Number(5)
PERCENT
ULOC_HEAD_TAX_METHOD
Varchar2(30)
VARCHAR30
ULOC_HEAD_TAX_AMOUNT
Number(18)
AMT12V6
UST_EIC_METHOD
Varchar2(30)
VARCHAR30
CREATE_DATE
Date()
DATE
CREATE_USER
Varchar2(30)
VARCHAR30
CHANGE_DATE
Date()
DATE
CHANGE_USER
Varchar2(30)
VARCHAR30
Hello, 10.86.0.2
Index
Recent Updates
Wiki Formatting
Search Help