Payroll Business Definitions
An integral part of the payroll setup is defining payroll business definitions. Use the Define Payroll Business Definitions task in the Define Payroll tasks list to create lookups, value sets, and descriptive flexfields that you need to support payroll.
You can view and edit several China-specific lookup tables used in the Oracle Fusion Payroll and Human Resource applications. These lookup tables comprise the valid values that you can select when completing specific fields in these applications.
To manage lookup tables for China, use these tasks in the Setup and Maintenance work area:
-
Manage Person Lookups for China
-
Manage Payroll Lookups for China
-
Manage Organization Structure Lookups for China
Person Lookups
You use person lookups in person and employment management tasks, such as Add Person, Hire Employee, and Manage Person Information. Use the Manage Person Lookups for China task to view and edit these lookups:
Lookup Type Name |
Lookup Type |
Where Lookup is Used |
---|---|---|
Notice Period Duration Unit |
HRX_CN_DURATION_UNIT |
Manage Employment page, Contract Details section |
Health Status |
HRX_CN_HEALTH_STATUS |
Manage Person Information page, Legislative Information section |
Hukou Location |
HRX_CN_HUKOU_LOCATION |
Manage Person Information page, Legislative Information section |
Hukou and Contribution Type |
HRX_CN_HUKOU_TYPE |
Manage Person Information page, Legislative Information section |
Copy of Personal File |
HRX_CN_FILE_ARCHIVE |
Additional Person Info page |
Military Level |
HRX_CN_MILITARY_LEVEL |
Additional Person Info page |
Party Membership Exceptional Status |
HRX_CN_PARTY_EXCEPTION |
Additional Person Info page |
Payroll Lookups
You use payroll lookups in the Manage Calculation Cards task and Regulatory and Tax Reporting processes and reports. Use the Manage Payroll Lookups for China task to view and edit these lookups:
Lookup Type Name |
Lookup Type |
Where Lookup is Used |
---|---|---|
Social Security Account Status Change Reason |
HRX_CN_ACCT_STATUS_CHG_REASON |
Manage Person Details page, Component Details section (Manage Calculation Cards task) |
Organization Lookups
You use organization lookups in the Manage Legal Entity HCM Information task. Use the Manage Organization Structures Lookups for China task to view and edit these lookups:
Lookup Type Name |
Lookup Type |
Where Lookup is Used |
---|---|---|
Enterprise Category |
HRX_CN_ENTERPRISE_CATEGORY |
Manage Legal Entity page, Chinese Legal Employer Details section |
Lookups
Lookups are lists of values in applications. Use lookups to provide validation or a list of values for a user input field in the user interface. You define a list of values as a lookup type consisting of a set of lookup codes, each code's translated meaning, and optionally a tag. The tags control which countries can have access to the lookup codes being defined. End users see the list of translated meanings as the available values for an object.
The following table lists the lookup types, lookup codes and their meaning for China.
Lookup Type |
Lookup Code |
Meaning |
---|---|---|
ORA_PER_ETHNICITY |
AC |
Achang |
ORA_PER_ETHNICITY |
BA |
Bai |
ORA_PER_ETHNICITY |
BL |
Blang |
ORA_PER_ETHNICITY |
BN |
Bonan |
ORA_PER_ETHNICITY |
BY |
Buyei |
ORA_PER_ETHNICITY |
CS |
Korean |
ORA_PER_ETHNICITY |
DA |
Dai |
ORA_PER_ETHNICITY |
DE |
Deang |
ORA_PER_ETHNICITY |
DO |
Dong |
ORA_PER_ETHNICITY |
DR |
Derung |
ORA_PER_ETHNICITY |
DU |
Daur |
ORA_PER_ETHNICITY |
DX |
Dongxiang |
ORA_PER_ETHNICITY |
EW |
Ewenki |
ORA_PER_ETHNICITY |
GI |
Gin |
ORA_PER_ETHNICITY |
GL |
Gelao |
ORA_PER_ETHNICITY |
GS |
Gaoshan |
ORA_PER_ETHNICITY |
HA |
Han |
ORA_PER_ETHNICITY |
HN |
Hani |
ORA_PER_ETHNICITY |
HU |
Hui |
ORA_PER_ETHNICITY |
HZ |
Hezhen |
ORA_PER_ETHNICITY |
JN |
Jino |
ORA_PER_ETHNICITY |
JP |
Jingpo |
ORA_PER_ETHNICITY |
KG |
Kirgiz |
ORA_PER_ETHNICITY |
KZ |
Kazak |
ORA_PER_ETHNICITY |
LB |
Lhoba |
ORA_PER_ETHNICITY |
LH |
Lahu |
ORA_PER_ETHNICITY |
LI |
Li |
ORA_PER_ETHNICITY |
LS |
Lisu |
ORA_PER_ETHNICITY |
MA |
Man |
ORA_PER_ETHNICITY |
MB |
Monba |
ORA_PER_ETHNICITY |
MG |
Mongol |
ORA_PER_ETHNICITY |
MH |
Miao |
ORA_PER_ETHNICITY |
ML |
Mulao |
ORA_PER_ETHNICITY |
MN |
Maonan |
ORA_PER_ETHNICITY |
NU |
Nu |
ORA_PER_ETHNICITY |
NX |
Naxi |
ORA_PER_ETHNICITY |
OR |
Oroqen |
ORA_PER_ETHNICITY |
PM |
Pumi |
ORA_PER_ETHNICITY |
QI |
Qiang |
ORA_PER_ETHNICITY |
RS |
Russ |
ORA_PER_ETHNICITY |
SH |
She |
ORA_PER_ETHNICITY |
SL |
Salar |
ORA_PER_ETHNICITY |
SU |
Sui |
ORA_PER_ETHNICITY |
TA |
Tajik |
ORA_PER_ETHNICITY |
TJ |
Tujia |
ORA_PER_ETHNICITY |
TT |
Tatar |
ORA_PER_ETHNICITY |
TU |
Tu |
ORA_PER_ETHNICITY |
UG |
Uygur |
ORA_PER_ETHNICITY |
UZ |
Uzbek |
ORA_PER_ETHNICITY |
VA |
Va |
ORA_PER_ETHNICITY |
XB |
Xibe |
ORA_PER_ETHNICITY |
YA |
Yao |
ORA_PER_ETHNICITY |
YG |
Yugur |
ORA_PER_ETHNICITY |
YI |
Yi |
ORA_PER_ETHNICITY |
ZA |
Zang |
ORA_PER_ETHNICITY |
ZH |
Zhuang |
ORA_PER_HIGHEST_EDUCATION_LEVE |
10 |
Graduate education |
ORA_PER_HIGHEST_EDUCATION_LEVE |
11 |
Graduation in a doctorate with diploma |
ORA_PER_HIGHEST_EDUCATION_LEVE |
12 |
Completion of a doctorate course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
13 |
Not completing a doctorate course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
14 |
Graduation in a master's degree with diploma |
ORA_PER_HIGHEST_EDUCATION_LEVE |
15 |
Completion of a master's degree course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
16 |
Not completing a master's degree course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
17 |
Graduation from graduate student class |
ORA_PER_HIGHEST_EDUCATION_LEVE |
18 |
Completion of a graduate student class course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
19 |
Not completing a graduate student class course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
20 |
University education |
ORA_PER_HIGHEST_EDUCATION_LEVE |
21 |
Graduation from university |
ORA_PER_HIGHEST_EDUCATION_LEVE |
22 |
Completion of a university course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
23 |
Not completing a university course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
28 |
Graduation from regular class at university |
ORA_PER_HIGHEST_EDUCATION_LEVE |
30 |
Specialized college education |
ORA_PER_HIGHEST_EDUCATION_LEVE |
31 |
Graduation from specialized college |
ORA_PER_HIGHEST_EDUCATION_LEVE |
32 |
Completion of a specialized college course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
33 |
Not completing a specialized college course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
40 |
Secondary vocational education |
ORA_PER_HIGHEST_EDUCATION_LEVE |
41 |
Graduation from secondary specialized school |
ORA_PER_HIGHEST_EDUCATION_LEVE |
42 |
Completion of a secondary specialized school course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
43 |
Not completing a secondary specialized school course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
44 |
Graduation from vocational school |
ORA_PER_HIGHEST_EDUCATION_LEVE |
45 |
Completion of a vocational school course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
46 |
Not completing a vocational school course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
47 |
Graduation from skilled workers training school |
ORA_PER_HIGHEST_EDUCATION_LEVE |
48 |
Completion of a skilled workers training school course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
49 |
Not completing a skilled workers training school course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
60 |
Regular high school education |
ORA_PER_HIGHEST_EDUCATION_LEVE |
61 |
Graduation from regular high school |
ORA_PER_HIGHEST_EDUCATION_LEVE |
62 |
Completion of a regular high school course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
63 |
Not completing a regular high school course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
70 |
Secondary school education |
ORA_PER_HIGHEST_EDUCATION_LEVE |
71 |
Graduation from secondary school |
ORA_PER_HIGHEST_EDUCATION_LEVE |
73 |
Not completing a secondary school course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
80 |
Primary school education |
ORA_PER_HIGHEST_EDUCATION_LEVE |
81 |
Graduation from primary school |
ORA_PER_HIGHEST_EDUCATION_LEVE |
83 |
Not completing a primary school course |
ORA_PER_HIGHEST_EDUCATION_LEVE |
90 |
Other |
ORA_PER_NATIONAL_IDENTIFIER_TY |
CIN |
Citizen Identification Number |
ORA_PER_VISA_PERMIT_TYPE |
CFRP |
Foreigner residence permit |
ORA_PER_VISA_PERMIT_TYPE |
CP |
Pass |
ORA_PER_VISA_PERMIT_TYPE |
CV |
Visa |
ORA_PER_VISA_PERMIT_TYPE |
CWP |
Work permit |
PER_PASSPORT_TYPE |
B |
Business usage |
PER_PASSPORT_TYPE |
N |
Not applicable |
PER_PASSPORT_TYPE |
P |
Private usage |
HRX_CN_ACCOUNT_STATUS |
CLOSED |
Closed |
HRX_CN_ACCOUNT_STATUS |
OPEN |
Open |
HRX_CN_ACCOUNT_STATUS |
SUSPEND |
Suspended |
HRX_CN_ACCOUNT_STATUS |
TRANSFER IN |
Transfer in |
HRX_CN_ACCOUNT_STATUS |
TRANSFER OUT |
Transfer out |
HRX_CN_ACCT_STATUS_CHG_REASON |
1 |
New enrollment |
HRX_CN_ACCT_STATUS_CHG_REASON |
2 |
Transfer in from same district |
HRX_CN_ACCT_STATUS_CHG_REASON |
3 |
Transfer in from same administrative area |
HRX_CN_ACCT_STATUS_CHG_REASON |
4 |
Transfer in from different administrative area |
HRX_CN_ACCT_STATUS_CHG_REASON |
5 |
Re-enrollment |
HRX_CN_ACCT_STATUS_CHG_REASON |
6 |
Retirement |
HRX_CN_ACCT_STATUS_CHG_REASON |
7 |
Transfer out to same administrative area |
HRX_CN_ACCT_STATUS_CHG_REASON |
8 |
Transfer out to different administrative area |
HRX_CN_ACCT_STATUS_CHG_REASON |
9 |
Termination of employment contract |
HRX_CN_ACCT_STATUS_CHG_REASON |
10 |
Death |
HRX_CN_ACCT_STATUS_CHG_REASON |
11 |
Other |
HRX_CN_CB_LOWER_CALC_METHOD |
CITY_AVERAGE:0.6 |
60 percent of city average monthly salary, previous year |
HRX_CN_CB_LOWER_CALC_METHOD |
CITY_LOWEST_AVERAGE |
City lowest average monthly salary, previous year |
HRX_CN_CB_LOWER_CALC_METHOD |
FIXED |
Fixed amount |
HRX_CN_CB_LOWER_CALC_METHOD |
NA |
Not applicable |
HRX_CN_CB_LOWER_CALC_METHOD |
PROVINCIAL_AVERAGE:0.6 |
60 percent of provincial average monthly salary, previous year |
HRX_CN_CB_SWITCH_MONTH |
1 |
January |
HRX_CN_CB_SWITCH_MONTH |
2 |
February |
HRX_CN_CB_SWITCH_MONTH |
3 |
March |
HRX_CN_CB_SWITCH_MONTH |
4 |
April |
HRX_CN_CB_SWITCH_MONTH |
5 |
May |
HRX_CN_CB_SWITCH_MONTH |
6 |
June |
HRX_CN_CB_SWITCH_MONTH |
7 |
July |
HRX_CN_CB_SWITCH_MONTH |
8 |
August |
HRX_CN_CB_SWITCH_MONTH |
9 |
September |
HRX_CN_CB_SWITCH_MONTH |
10 |
October |
HRX_CN_CB_SWITCH_MONTH |
11 |
November |
HRX_CN_CB_SWITCH_MONTH |
12 |
December |
HRX_CN_CB_SWITCH_MONTH |
NA |
Not applicable |
HRX_CN_CB_SWITCH_PERIOD_TYPE |
MONTHLY |
Monthly |
HRX_CN_CB_SWITCH_PERIOD_TYPE |
YEARLY |
Yearly in a specified month |
HRX_CN_CB_UPPER_CALC_METHOD |
CITY_AVERAGE:3 |
3 times city average monthly salary, previous year |
HRX_CN_CB_UPPER_CALC_METHOD |
CITY_AVERAGE:5 |
5 times city average monthly salary, previous year |
HRX_CN_CB_UPPER_CALC_METHOD |
FIXED |
Fixed amount |
HRX_CN_CB_UPPER_CALC_METHOD |
NA |
Not applicable |
HRX_CN_CB_UPPER_CALC_METHOD |
PROVINCIAL_AVERAGE:3 |
3 times provincial average monthly salary, previous year |
HRX_CN_CONT_BASE_CALC_METHOD |
AVERAGE |
Average monthly salary in previous year |
HRX_CN_CONT_BASE_CALC_METHOD |
CITY_AVERAGE:0.6 |
60 percent of city average monthly salary in previous year |
HRX_CN_CONT_BASE_CALC_METHOD |
CITY_LOWEST_AVERAGE |
City lowest average monthly salary in previous year |
HRX_CN_CONT_BASE_CALC_METHOD |
CURRENT |
Current monthly salary |
HRX_CN_CONT_BASE_CALC_METHOD |
FIXED |
Fixed amount |
HRX_CN_CONT_BASE_CALC_METHOD |
NA |
Not applicable |
HRX_CN_CONT_BASE_CALC_METHOD |
PREVIOUS |
Previous monthly salary |
HRX_CN_CONT_BASE_CALC_METHOD |
PREVIOUS_SWITCH |
Monthly salary in previous month of switch month |
HRX_CN_CONT_BASE_CALC_METHOD |
PROVINCIAL_AVERAGE:0.6 |
60 percent of provincial average monthly salary last year |
HRX_CN_DOC_TYPE_AND_FORMULA |
FOREIGNER_CODE |
Foreigner Code |
HRX_CN_DOC_TYPE_AND_FORMULA |
FORMULA1 |
Formula 1 |
HRX_CN_DOC_TYPE_AND_FORMULA |
HK_MACAO_TAIWAN_PASS |
Hong Kong, Macao, or Taiwan Pass |
HRX_CN_DOC_TYPE_AND_FORMULA |
IDENT |
Identification |
HRX_CN_DOC_TYPE_AND_FORMULA |
PASSPORT |
Passport |
HRX_CN_DURATION_UNIT |
D |
Days |
HRX_CN_DURATION_UNIT |
M |
Months |
HRX_CN_DURATION_UNIT |
W |
Weeks |
HRX_CN_DURATION_UNIT |
Y |
Years |
HRX_CN_ENTERPRISE_CATEGORY |
1 |
Juridical enterprise |
HRX_CN_ENTERPRISE_CATEGORY |
2 |
Juridical institution |
HRX_CN_ENTERPRISE_CATEGORY |
3 |
Juridical association |
HRX_CN_ENTERPRISE_CATEGORY |
4 |
Juridical government organization |
HRX_CN_ENTERPRISE_CATEGORY |
5 |
Nonjuridical enterprise |
HRX_CN_ENTERPRISE_CATEGORY |
6 |
Nonjuridical institution |
HRX_CN_ENTERPRISE_CATEGORY |
7 |
Nonjuridical association |
HRX_CN_ENTERPRISE_CATEGORY |
8 |
Nonjuridical government organization |
HRX_CN_FILE_ARCHIVE |
1 |
No file exists |
HRX_CN_FILE_ARCHIVE |
2 |
Original copy |
HRX_CN_FILE_ARCHIVE |
3 |
Secondary copy |
HRX_CN_FILE_ARCHIVE |
4 |
Film |
HRX_CN_FILE_ARCHIVE |
5 |
Original copy, secondary copy, and film |
HRX_CN_FILE_ARCHIVE |
6 |
Original copy and secondary copy |
HRX_CN_FILE_ARCHIVE |
7 |
Original copy and film |
HRX_CN_FILE_ARCHIVE |
8 |
Secondary copy and film |
HRX_CN_FILE_ARCHIVE |
9 |
Other |
HRX_CN_HEALTH_STATUS |
C |
Ill |
HRX_CN_HEALTH_STATUS |
D |
Disabled |
HRX_CN_HEALTH_STATUS |
H |
Healthy |
HRX_CN_HEALTH_STATUS |
P |
Physiological defect |
HRX_CN_HEALTH_STATUS |
W |
Normal |
HRX_CN_HUKOU_LOCATION |
110000 |
Beijing Shi |
HRX_CN_HUKOU_LOCATION |
120000 |
Tianjin Shi |
HRX_CN_HUKOU_LOCATION |
130000 |
Hebei Sheng |
HRX_CN_HUKOU_LOCATION |
140000 |
Shanxi Sheng |
HRX_CN_HUKOU_LOCATION |
150000 |
Nei Mongol Zizhiqu |
HRX_CN_HUKOU_LOCATION |
210000 |
Liaoning Sheng |
HRX_CN_HUKOU_LOCATION |
220000 |
Jilin Sheng |
HRX_CN_HUKOU_LOCATION |
230000 |
Heilongjiang Sheng |
HRX_CN_HUKOU_LOCATION |
310000 |
Shanghai Shi |
HRX_CN_HUKOU_LOCATION |
320000 |
Jiangsu Sheng |
HRX_CN_HUKOU_LOCATION |
330000 |
Zhejiang Sheng |
HRX_CN_HUKOU_LOCATION |
340000 |
Anhui Sheng |
HRX_CN_HUKOU_LOCATION |
350000 |
Fujian Sheng |
HRX_CN_HUKOU_LOCATION |
360000 |
Jiangxi Sheng |
HRX_CN_HUKOU_LOCATION |
370000 |
Shandong Sheng |
HRX_CN_HUKOU_LOCATION |
410000 |
Henan Sheng |
HRX_CN_HUKOU_LOCATION |
420000 |
Hubei Sheng |
HRX_CN_HUKOU_LOCATION |
430000 |
Hunan Sheng |
HRX_CN_HUKOU_LOCATION |
440000 |
Guangdong Sheng |
HRX_CN_HUKOU_LOCATION |
450000 |
Guangxi Zhuangzu Zizhiqu |
HRX_CN_HUKOU_LOCATION |
460000 |
Hainan Sheng |
HRX_CN_HUKOU_LOCATION |
500000 |
Chongqing Shi |
HRX_CN_HUKOU_LOCATION |
510000 |
Sichuan Sheng |
HRX_CN_HUKOU_LOCATION |
520000 |
Guizhou Sheng |
HRX_CN_HUKOU_LOCATION |
530000 |
Yunnan Sheng |
HRX_CN_HUKOU_LOCATION |
540000 |
Xizang Zizhiqu |
HRX_CN_HUKOU_LOCATION |
610000 |
Shaanxi Sheng |
HRX_CN_HUKOU_LOCATION |
620000 |
Gansu Sheng |
HRX_CN_HUKOU_LOCATION |
630000 |
Qinghai Sheng |
HRX_CN_HUKOU_LOCATION |
640000 |
Ningxia Huizu Zizhiqu |
HRX_CN_HUKOU_LOCATION |
650000 |
Xinjiang Uygur Zizhiqu |
HRX_CN_HUKOU_LOCATION |
710000 |
Taiwan Sheng |
HRX_CN_HUKOU_LOCATION |
810000 |
Hong Kong "Tebiexingzhengqu" |
HRX_CN_HUKOU_LOCATION |
820000 |
Macao "Tebiexingzhengqu" |
HRX_CN_HUKOU_LOCATION |
990000 |
Other |
HRX_CN_HUKOU_TYPE |
1 |
Farmer |
HRX_CN_HUKOU_TYPE |
2 |
City resident |
HRX_CN_HUKOU_TYPE |
3 |
Local farmer |
HRX_CN_HUKOU_TYPE |
4 |
Nonlocal farmer |
HRX_CN_HUKOU_TYPE |
5 |
Local city resident - permanent |
HRX_CN_HUKOU_TYPE |
6 |
Local city resident - temporary |
HRX_CN_HUKOU_TYPE |
7 |
Nonlocal city resident |
HRX_CN_HUKOU_TYPE |
9 |
Other |
HRX_CN_INS_CONT_DEFERRED_TYPE |
CURRENT_PERIOD |
Defer until probation period end date |
HRX_CN_INS_CONT_DEFERRED_TYPE |
NA |
Not applicable |
HRX_CN_INS_CONT_DEFERRED_TYPE |
NEXT_PERIOD |
Defer until next month of probation period end date |
HRX_CN_LESS_THAN_ONE_YUAN |
LESS_THAN |
No payment if tax payable less than one yuan |
HRX_CN_LESS_THAN_ONE_YUAN |
LESS_THAN_OR_EQUAL |
No payment if tax payable less than or equal to one yuan |
HRX_CN_LESS_THAN_ONE_YUAN |
NO_EXEMPTION |
No exemption |
HRX_CN_MILITARY_LEVEL |
1 |
Army |
HRX_CN_MILITARY_LEVEL |
2 |
Deputy Army |
HRX_CN_MILITARY_LEVEL |
3 |
Division |
HRX_CN_MILITARY_LEVEL |
4 |
Deputy Division |
HRX_CN_MILITARY_LEVEL |
5 |
Regiment |
HRX_CN_MILITARY_LEVEL |
6 |
Deputy Regiment |
HRX_CN_MILITARY_LEVEL |
7 |
Battalion |
HRX_CN_MILITARY_LEVEL |
8 |
Deputy Battalion |
HRX_CN_MILITARY_LEVEL |
9 |
Company |
HRX_CN_MILITARY_LEVEL |
10 |
Deputy Company |
HRX_CN_MILITARY_LEVEL |
11 |
Platoon |
HRX_CN_MILITARY_RANK |
11 |
Second lieutenant |
HRX_CN_MILITARY_RANK |
12 |
First lieutenant |
HRX_CN_MILITARY_RANK |
13 |
Captain |
HRX_CN_MILITARY_RANK |
21 |
Major |
HRX_CN_MILITARY_RANK |
22 |
Lieutenant colonel |
HRX_CN_MILITARY_RANK |
23 |
Colonel |
HRX_CN_MILITARY_RANK |
24 |
Senior colonel |
HRX_CN_MILITARY_RANK |
31 |
Major general |
HRX_CN_MILITARY_RANK |
32 |
Lieutenant general |
HRX_CN_MILITARY_RANK |
33 |
General |
HRX_CN_MILITARY_RANK |
34 |
Senior general |
HRX_CN_PARTY_EXCEPTION |
1 |
Transferred from Communist Youth League |
HRX_CN_PARTY_EXCEPTION |
2 |
Rejoined the party |
HRX_CN_PARTY_EXCEPTION |
11 |
Granting of formal membership postponed |
HRX_CN_PARTY_EXCEPTION |
21 |
Registration not granted |
HRX_CN_PARTY_EXCEPTION |
22 |
Registration postponed |
HRX_CN_PARTY_EXCEPTION |
31 |
Left the party automatically |
HRX_CN_PARTY_EXCEPTION |
32 |
Name removed from the membership roll |
HRX_CN_PARTY_EXCEPTION |
33 |
Probationary party member qualification canceled |
HRX_CN_PARTY_EXCEPTION |
34 |
Dismissed from the party |
HRX_CN_PARTY_EXCEPTION |
99 |
Other |
HRX_CN_PARTY_STATUS |
FR |
Formal |
HRX_CN_PARTY_STATUS |
OT |
Other |
HRX_CN_PARTY_STATUS |
PR |
Probationary |
HRX_CN_PARTY_STATUS |
QT |
Resigned |
HRX_CN_PARTY_TYPE |
1 |
Member of the Communist Party of China |
HRX_CN_PARTY_TYPE |
2 |
Probationary member of Communist Party of China |
HRX_CN_PARTY_TYPE |
3 |
Member of the Communist Youth League of China |
HRX_CN_PARTY_TYPE |
4 |
Member of the Kuomingtang Revolution Committee of China |
HRX_CN_PARTY_TYPE |
5 |
Member of China Democratic League |
HRX_CN_PARTY_TYPE |
6 |
Member of China Democratic Construction Association |
HRX_CN_PARTY_TYPE |
7 |
Member of China Association of Promoting Democracy |
HRX_CN_PARTY_TYPE |
8 |
Member of China Peasants' and Workers' Democratic Party |
HRX_CN_PARTY_TYPE |
9 |
Member of China Zhi Gong Dang |
HRX_CN_PARTY_TYPE |
10 |
Member of Jiu San Society |
HRX_CN_PARTY_TYPE |
11 |
Member of Taiwan Democratic Self-Government |
HRX_CN_PARTY_TYPE |
12 |
Public figure without party affiliation |
HRX_CN_PARTY_TYPE |
13 |
General public without party affiliation |
HRX_CN_ROUNDING_METHOD |
ROUNDDOWN_CENT |
Round down to nearest cent |
HRX_CN_ROUNDING_METHOD |
ROUNDDOWN_JIAO |
Round down to nearest jiao |
HRX_CN_ROUNDING_METHOD |
ROUNDDOWN_YUAN |
Round down to nearest yuan |
HRX_CN_ROUNDING_METHOD |
ROUNDUP_JIAO |
Round up to nearest jiao |
HRX_CN_ROUNDING_METHOD |
ROUNDUP_YUAN |
Round up to nearest yuan |
HRX_CN_ROUNDING_METHOD |
ROUND_CENT |
Round to nearest cent |
HRX_CN_ROUNDING_METHOD |
ROUND_JIAO |
Round to nearest jiao |
HRX_CN_ROUNDING_METHOD |
ROUND_YUAN |
Round to nearest yuan |
HRX_CN_SUB_RELATIONSHIP |
10 |
Central government |
HRX_CN_SUB_RELATIONSHIP |
20 |
Province |
HRX_CN_SUB_RELATIONSHIP |
40 |
City and region |
HRX_CN_SUB_RELATIONSHIP |
50 |
County |
HRX_CN_SUB_RELATIONSHIP |
60 |
Street, town, and township |
HRX_CN_SUB_RELATIONSHIP |
61 |
Street |
HRX_CN_SUB_RELATIONSHIP |
62 |
Town |
HRX_CN_SUB_RELATIONSHIP |
63 |
Township |
HRX_CN_SUB_RELATIONSHIP |
70 |
Resident and villager committee |
HRX_CN_SUB_RELATIONSHIP |
71 |
Resident committee |
HRX_CN_SUB_RELATIONSHIP |
72 |
Villager committee |
HRX_CN_SUB_RELATIONSHIP |
90 |
Other |
HRX_CN_TAX_EXEMPTION_CATEGORY |
CNRESCN |
Mainland China resident with mainland China income |
HRX_CN_TAX_EXEMPTION_CATEGORY |
FOREIGNER |
Foreigner |
HRX_CN_TAX_EXEMPTION_CATEGORY |
HMT |
Hong Kong, Macao, or Taiwan resident |
HRX_CN_TAX_EXEMPTION_CATEGORY |
OVERSEAS |
Overseas Chinese |
HRX_CN_TAX_EXEMPTION_CATEGORY |
SEAMAN |
Seaman |
HRX_CN_UNIT_LEVEL |
1 |
Central government |
HRX_CN_UNIT_LEVEL |
3 |
Province or ministry |
HRX_CN_UNIT_LEVEL |
4 |
Deputy province or ministry |
HRX_CN_UNIT_LEVEL |
5 |
Region or bureau |
HRX_CN_UNIT_LEVEL |
6 |
Deputy region or bureau |
HRX_CN_UNIT_LEVEL |
7 |
County |
HRX_CN_UNIT_LEVEL |
8 |
Deputy county |
HRX_CN_UNIT_LEVEL |
9 |
Section |
HRX_CN_UNIT_LEVEL |
10 |
Deputy section |
ORA_HRX_CN_SEV_PAY_TAX_YOS_CAL |
ORA_ADD_HALF_A_YEAR |
Add 0.5 if less than 6 months, add 1 if more than 6 months |
ORA_HRX_CN_SEV_PAY_TAX_YOS_CAL |
ORA_ADD_ONE_YEAR |
Add 1 for less than a year period |
ORA_HRX_CN_TAX_CAL_METHOD |
ORA_ACCUMULATIVE |
Accumulative Withholding Method |
ORA_HRX_CN_TAX_CAL_METHOD |
ORA_MONTHLY |
Monthly Withholding Method |
ORA_HRX_CN_TAX_EXEMPT_METHOD |
INCREMENT |
Increment on a monthly basis if income is greater than 0 |
ORA_HRX_CN_TAX_EXEMPT_METHOD |
MULTIPLY |
Multiply by number of calendar months |
Consider the following when managing lookups.
-
Using lookups in applications
-
Configurable levels
-
Accessing lookups
-
Enabling lookups
-
The three kinds of lookups: standard, common, and set enabled
Descriptive Flexfields
Use descriptive flexfields to add customer-defined attributes to business object entities, and define validation for them.
All the business object entities that you can use in the application are enabled for descriptive flexfields. However, configuring descriptive flexfields is an optional task.
Configuring descriptive flexfields involves managing the available flexfields registered with your Oracle Applications Cloud database and configuring their flexfield-level properties, defining and managing descriptive flexfield contexts, and configuring global and context-sensitive segments.
Extensible Flexfields
Extensible flexfields are like descriptive flexfields, with some additional features.
Unlike descriptive flexfields, the columns corresponding to extensible flexfields segments are part of specific tables, separate from the base application table. Unlike descriptive flexfield contexts, the set of attributes in an extensible flexfield context remains constant and doesn't differ by context value.
An extensible flexfield describes an application entity, with the run time ability to expand the database that implementation consultants can use to define the data structure that appears in the application.
Extensible flexfields support one-to-many relationships between the entity and the modified attribute rows.
To get a list of predefined extensible flexfields, open the Setup and Maintenance work area, and use the Manage Extensible Flexfields task.
Consider these aspects to understand extensible flexfields:
-
Usages
-
Categories
-
Pages
-
Security
-
Protected Extensible Flexfield Data
Value Sets
A value set is a group of valid values that you assign to a flexfield segment to control the values that are stored for business object attributes.
An end user enters a value for an attribute of a business object while using the application. The flexfield validates the value against the set of valid values that you configured as a value set and assigned to the segment.
For example, you can define a required format, such as a five digit number, or a list of valid values, such as green, red, and blue.