[Home] [Help]
[Dependency Information]
Object Name: | SSHR_SAL_PROP_OBJ_TYP |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
PAY_PROPOSAL_ID | NUMBER |
|
|
ASSIGNMENT_ID | NUMBER |
|
|
BUSINESS_GROUP_ID | NUMBER |
|
|
EFFECTIVE_DATE | DATE |
|
|
COMMENTS | VARCHAR2 | (2000) | |
NEXT_SAL_REVIEW_DATE | DATE |
|
|
SALARY_CHANGE_AMOUNT | NUMBER |
|
|
SALARY_CHANGE_PERCENT | NUMBER |
|
|
ANNUAL_CHANGE | NUMBER |
|
|
PROPOSED_SALARY | NUMBER |
|
|
PROPOSED_PERCENT | NUMBER |
|
|
PROPOSAL_REASON | VARCHAR2 | (30) | |
RANKING | NUMBER |
|
|
CURRENT_SALARY | NUMBER |
|
|
PERFORMANCE_REVIEW_ID | NUMBER |
|
|
MULTIPLE_COMPONENTS | VARCHAR2 | (1) | |
ELEMENT_ENTRY_ID | NUMBER |
|
|
SELECTION_MODE | VARCHAR2 | (1) | |
OVN | NUMBER |
|
|
CURRENCY | VARCHAR2 | (15) | |
PAY_BASIS_NAME | VARCHAR2 | (80) | |
ANNUAL_EQUIVALENT | NUMBER |
|
|
TOTAL_PERCENT | NUMBER |
|
|
QUARTILE | NUMBER |
|
|
COMPARATIO | NUMBER |
|
|
LV_SELECTION_MODE | VARCHAR2 | (1) | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | |
ATTRIBUTE1 | VARCHAR2 | (150) | |
ATTRIBUTE2 | VARCHAR2 | (150) | |
ATTRIBUTE3 | VARCHAR2 | (150) | |
ATTRIBUTE4 | VARCHAR2 | (150) | |
ATTRIBUTE5 | VARCHAR2 | (150) | |
ATTRIBUTE6 | VARCHAR2 | (150) | |
ATTRIBUTE7 | VARCHAR2 | (150) | |
ATTRIBUTE8 | VARCHAR2 | (150) | |
ATTRIBUTE9 | VARCHAR2 | (150) | |
ATTRIBUTE10 | VARCHAR2 | (150) | |
ATTRIBUTE11 | VARCHAR2 | (150) | |
ATTRIBUTE12 | VARCHAR2 | (150) | |
ATTRIBUTE13 | VARCHAR2 | (150) | |
ATTRIBUTE14 | VARCHAR2 | (150) | |
ATTRIBUTE15 | VARCHAR2 | (150) | |
ATTRIBUTE16 | VARCHAR2 | (150) | |
ATTRIBUTE17 | VARCHAR2 | (150) | |
ATTRIBUTE18 | VARCHAR2 | (150) | |
ATTRIBUTE19 | VARCHAR2 | (150) | |
ATTRIBUTE20 | VARCHAR2 | (150) | |
NO_OF_COMPONENTS | NUMBER |
|
|
SALARY_BASIS_CHANGE_TYPE | VARCHAR2 | (30) | |
DEFAULT_DATE | DATE |
|
|
DEFAULT_BG_ID | NUMBER |
|
|
DEFAULT_CURRENCY | VARCHAR2 | (15) | |
DEFAULT_FORMAT_STRING | VARCHAR2 | (40) | |
DEFAULT_SALARY_BASIS_NAME | VARCHAR2 | (30) | |
DEFAULT_PAY_BASIS_NAME | VARCHAR2 | (80) | |
DEFAULT_PAY_BASIS | VARCHAR2 | (30) | |
DEFAULT_PAY_ANNUAL_FACTOR | NUMBER |
|
|
DEFAULT_GRADE | VARCHAR2 | (240) | |
DEFAULT_GRADE_ANNUAL_FACTOR | NUMBER |
|
|
DEFAULT_MINIMUM_SALARY | NUMBER |
|
|
DEFAULT_MAXIMUM_SALARY | NUMBER |
|
|
DEFAULT_MIDPOINT_SALARY | NUMBER |
|
|
DEFAULT_PREV_SALARY | NUMBER |
|
|
DEFAULT_LAST_CHANGE_DATE | DATE |
|
|
DEFAULT_ELEMENT_ENTRY_ID | NUMBER |
|
|
DEFAULT_BASIS_CHANGED | NUMBER |
|
|
DEFAULT_UOM | VARCHAR2 | (30) | |
DEFAULT_GRADE_UOM | VARCHAR2 | (30) | |
DEFAULT_CHANGE_AMOUNT | NUMBER |
|
|
DEFAULT_CHANGE_PERCENT | NUMBER |
|
|
DEFAULT_QUARTILE | NUMBER |
|
|
DEFAULT_COMPARATIO | NUMBER |
|
|
DEFAULT_LAST_PAY_CHANGE | VARCHAR2 | (200) | |
DEFAULT_FLSA_STATUS | VARCHAR2 | (80) | |
DEFAULT_CURRENCY_SYMBOL | VARCHAR2 | (4) | |
DEFAULT_PRECISION | NUMBER |
|
|
SALARY_EFFECTIVE_DATE | DATE |
|
|
GSP_DUMMY_TXN | VARCHAR2 | (30) | |
CHG_AMT_MC | VARCHAR2 | (100) | |
CURR_SAL_MC | VARCHAR2 | (100) | |
PROP_SAL_MC | VARCHAR2 | (100) | |
CURR_ANN_EQV_MC | VARCHAR2 | (100) | |
PROP_ANN_EQV_MC | VARCHAR2 | (100) |
|
|
|