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

TABLE: BEN.BEN_PRTT_REIMBMT_RQST_F

Object Details
Object Name: BEN_PRTT_REIMBMT_RQST_F
Object Type: TABLE
Owner: BEN
FND Design Data: TableBEN.BEN_PRTT_REIMBMT_RQST_F
Subobject Name:
Status: VALID


BEN_PRTT_REIMBMT_RQST_F identifies the details associated with a participant request for reimbursement under a plan, for example, business expense reimbursements or United States Healthcare Spending Account.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_PRTT_REIMBMT_RQST_F_PK
  1. ColumnPRTT_REIMBMT_RQST_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
BEN_PRTT_REIMBMT_RQST_F_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRTT_REIMBMT_RQST_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
BEN_PRTT_REIMBMT_RQST_F_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
BEN_PRTT_REIMBMT_RQST_F_FK6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGD_OR_SVC_TYP_ID
BEN_PRTT_REIMBMT_RQST_F_FK7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTACT_RELATIONSHIP_ID
BEN_PRTT_REIMBMT_RQST_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPL_ID
BEN_PRTT_REIMBMT_RQST_F_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUBMITTER_PERSON_ID
BEN_PRTT_REIMBMT_RQST_F_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROVIDER_PERSON_ID
BEN_PRTT_REIMBMT_RQST_F_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECIPIENT_PERSON_ID
BEN_PRTT_REIMBMT_RQST_F_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROVIDER_SSN_PERSON_ID
Columns
Name Datatype Length Mandatory Comments
PRTT_REIMBMT_RQST_ID NUMBER (15) Yes System generated primary key column.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign Key to HR_ORGANIZATION_UNITS
PL_ID NUMBER (15) Yes Foreign Key to BEN_PL_F.
INCRD_FROM_DT DATE

Increased from date.
INCRD_TO_DT DATE

Increased to date.
RQST_NUM NUMBER (15)
Request number.
RQST_AMT NUMBER (15)
Request amount.
RQST_AMT_UOM VARCHAR2 (30)
Request amount unit of measure.
RQST_BTCH_NUM NUMBER (15)
Request batch number.
PRTT_REIMBMT_RQST_STAT_CD VARCHAR2 (30)
Participant reimbursement request status.
REIMBMT_CTFN_TYP_PRVDD_CD VARCHAR2 (30)
Reimbursement certification type.
SUBMITTER_PERSON_ID NUMBER (15)
Foreign key to PER_PEOPLE_F.
RCRRG_CD VARCHAR2 (30)
Recurring code.
PROVIDER_PERSON_ID NUMBER (15)
Foreign key to PER_PEOPLE_F.
GD_OR_SVC_TYP_ID NUMBER (15)
Foreign key to BEN_GD_OR_SVC_TYP.
RECIPIENT_PERSON_ID NUMBER (15)
Foreign key to PER_PEOPLE_F.
PROVIDER_SSN_PERSON_ID NUMBER (15)
Provider Social Security Number.
PRC_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column.
PRC_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRC_ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield segment column.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated primary key. Increments by one each update.
CONTACT_RELATIONSHIP_ID NUMBER (15)
Foreign key to PER_CONTACT_RELATIONSHIPS.
PRTT_ENRT_RSLT_ID NUMBER (15)
Foreign key to BEN_PRTT_ENRT_RSLT_F.
STAT_RSN_CD VARCHAR2 (30)
Request Status Reason.
PYMT_STAT_CD VARCHAR2 (30)
Approved for Payment Status.
PYMT_STAT_RSN_CD VARCHAR2 (30)
Approved for Payment Reason.
STAT_OVRDN_FLAG VARCHAR2 (30)
Request Status Overridden Y or N.
STAT_OVRDN_RSN_CD VARCHAR2 (30)
Request Status Overridden Reason.
STAT_PRR_TO_OVRD VARCHAR2 (30)
Resuest Status Prior to Override.
PYMT_STAT_OVRDN_FLAG VARCHAR2 (30)
Payment Status Overridden.
PYMT_STAT_OVRDN_RSN_CD VARCHAR2 (30)
Payment Status Overridden Reason.
PYMT_STAT_PRR_TO_OVRD VARCHAR2 (30)
Payment Status Prior to override.
ADJMT_FLAG VARCHAR2 (30)
Adjustment Flag.
SUBMTD_DT DATE

Submitted Date.
TTL_RQST_AMT NUMBER

Total Request Amount.
APRVD_FOR_PYMT_AMT NUMBER

Approved for Payment Amount.
COMMENT_ID NUMBER (15)
Foreign key to FND_ATTACHED_DOCUMENTS
EXP_INCURD_DT DATE

Expense incurred date.
OPT_ID NUMBER

To capture option_id if some one defines a reimbursement plan with Options
POPL_YR_PERD_ID_1 NUMBER

To capture applicable plan year 1
POPL_YR_PERD_ID_2 NUMBER

To capture applicable plan year 2
AMT_YEAR1 NUMBER

To capture the amount for year 1
AMT_YEAR2 NUMBER

To capture the amount for year 2
Query Text

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


SELECT PRTT_REIMBMT_RQST_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      PL_ID
,      INCRD_FROM_DT
,      INCRD_TO_DT
,      RQST_NUM
,      RQST_AMT
,      RQST_AMT_UOM
,      RQST_BTCH_NUM
,      PRTT_REIMBMT_RQST_STAT_CD
,      REIMBMT_CTFN_TYP_PRVDD_CD
,      SUBMITTER_PERSON_ID
,      RCRRG_CD
,      PROVIDER_PERSON_ID
,      GD_OR_SVC_TYP_ID
,      RECIPIENT_PERSON_ID
,      PROVIDER_SSN_PERSON_ID
,      PRC_ATTRIBUTE_CATEGORY
,      PRC_ATTRIBUTE1
,      PRC_ATTRIBUTE2
,      PRC_ATTRIBUTE3
,      PRC_ATTRIBUTE4
,      PRC_ATTRIBUTE5
,      PRC_ATTRIBUTE6
,      PRC_ATTRIBUTE7
,      PRC_ATTRIBUTE8
,      PRC_ATTRIBUTE9
,      PRC_ATTRIBUTE10
,      PRC_ATTRIBUTE11
,      PRC_ATTRIBUTE12
,      PRC_ATTRIBUTE13
,      PRC_ATTRIBUTE14
,      PRC_ATTRIBUTE15
,      PRC_ATTRIBUTE16
,      PRC_ATTRIBUTE17
,      PRC_ATTRIBUTE18
,      PRC_ATTRIBUTE19
,      PRC_ATTRIBUTE20
,      PRC_ATTRIBUTE21
,      PRC_ATTRIBUTE22
,      PRC_ATTRIBUTE23
,      PRC_ATTRIBUTE24
,      PRC_ATTRIBUTE25
,      PRC_ATTRIBUTE26
,      PRC_ATTRIBUTE27
,      PRC_ATTRIBUTE28
,      PRC_ATTRIBUTE29
,      PRC_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      CONTACT_RELATIONSHIP_ID
,      PRTT_ENRT_RSLT_ID
,      STAT_RSN_CD
,      PYMT_STAT_CD
,      PYMT_STAT_RSN_CD
,      STAT_OVRDN_FLAG
,      STAT_OVRDN_RSN_CD
,      STAT_PRR_TO_OVRD
,      PYMT_STAT_OVRDN_FLAG
,      PYMT_STAT_OVRDN_RSN_CD
,      PYMT_STAT_PRR_TO_OVRD
,      ADJMT_FLAG
,      SUBMTD_DT
,      TTL_RQST_AMT
,      APRVD_FOR_PYMT_AMT
,      COMMENT_ID
,      EXP_INCURD_DT
,      OPT_ID
,      POPL_YR_PERD_ID_1
,      POPL_YR_PERD_ID_2
,      AMT_YEAR1
,      AMT_YEAR2
FROM BEN.BEN_PRTT_REIMBMT_RQST_F;

Dependencies

[top of page]

BEN.BEN_PRTT_REIMBMT_RQST_F does not reference any database object

BEN.BEN_PRTT_REIMBMT_RQST_F is referenced by following:

SchemaAPPS
SynonymBEN_PRTT_REIMBMT_RQST_F
TriggerBEN_PRTT_REIMBMT_RQST_F_WHO