DBA Data[Home] [Help] [Dependency Information]


TABLE: HR.PAY_IE_SOCIAL_BENEFITS_F

Object Details
Object Name: PAY_IE_SOCIAL_BENEFITS_F
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_IE_SOCIAL_BENEFITS_F
Subobject Name:
Status: VALID


Table to store Social Benefit Details for an Assignment


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PAY_IE_SOCIAL_BENEFITS_F_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOCIAL_BENEFIT_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
PAY_IE_SOCIAL_BENEFITS_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
Columns
Name Datatype Length Mandatory Comments
SOCIAL_BENEFIT_ID NUMBER (10) Yes System-generated primary key column.
EFFECTIVE_START_DATE DATE
Yes Date Track Effective Start Date
EFFECTIVE_END_DATE DATE
Yes Date Track Effective End Date
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object Version Number
ASSIGNMENT_ID NUMBER (10) Yes Foreign key to PER_ALL_ASSIGNMENTS_F Table
ABSENCE_START_DATE DATE

Absence start Date derived from the absence management system
ABSENCE_END_DATE DATE

Absence End Date derived from the absence management system
BENEFIT_AMOUNT NUMBER
Yes Benefit Amount,Initially defaulted from global value
BENEFIT_TYPE VARCHAR2 (30)
Benefit Type ie Sickness or Occupational Injury Benefit
CALCULATION_OPTION VARCHAR2 (30) Yes Calculation Option ie. option 1,2 or 3
REDUCED_TAX_CREDIT NUMBER

Reduced Tax Credit amount derived from PAYE and Taxable Benefit Amount,if option is 2
REDUCED_STANDARD_CUTOFF NUMBER

Reduced Standard Cutoff derived fom PAYE and Benefit percentage if option is 2
INCIDENT_ID NUMBER (15)
Incident ID ,refernced from per_work_incidents
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER (15)
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 NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID VARCHAR2 (240)
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 DATE

Concurrent Program who column - date when a program last updated this row).
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SOCIAL_BENEFIT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      OBJECT_VERSION_NUMBER
,      ASSIGNMENT_ID
,      ABSENCE_START_DATE
,      ABSENCE_END_DATE
,      BENEFIT_AMOUNT
,      BENEFIT_TYPE
,      CALCULATION_OPTION
,      REDUCED_TAX_CREDIT
,      REDUCED_STANDARD_CUTOFF
,      INCIDENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM HR.PAY_IE_SOCIAL_BENEFITS_F;

Dependencies

[top of page]

HR.PAY_IE_SOCIAL_BENEFITS_F does not reference any database object

HR.PAY_IE_SOCIAL_BENEFITS_F is referenced by following:

SchemaAPPS
SynonymPAY_IE_SOCIAL_BENEFITS_F
TriggerPAY_IE_SOCIAL_BENEFITS_F_WHO
SchemaPUBLIC
SynonymPAY_IE_SOCIAL_BENEFITS_F