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

TABLE: BEN.BEN_PRTT_RMT_APRVD_FR_PYMT_F

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


Prtt Rmt Aprvd Fr Pymt


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_PRTT_RMT_APRVD_FR_PYMT_PK
  1. ColumnPRTT_RMT_APRVD_FR_PYMT_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
BEN_PRTT_RMT_APRVD_FR_PYMT_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRTT_RMT_APRVD_FR_PYMT_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
BEN_PRTT_RMT_APRVD_FR_PYMT_DT1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRTT_REIMBMT_RQST_ID
BEN_PRTT_RMT_APRVD_FR_PYMT_DT2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
PRTT_RMT_APRVD_FR_PYMT_ID NUMBER (15) Yes System generated primary key column.
PRTT_REIMBMT_RQST_ID NUMBER (15) Yes Foreign Key to BEN_PRTT_REIMBMT_RQST_F.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
APPRVD_FR_PYMT_NUM NUMBER (15)
Approved For Payment Number.
ADJMT_FLAG VARCHAR2 (30)
Adjustment Flag Y or N.
APRVD_FR_PYMT_AMT NUMBER

Approved for Payment Amount.
PYMT_STAT_CD VARCHAR2 (30)
Payment Status Code.
PYMT_STAT_RSN_CD VARCHAR2 (30)
Payment Status Reason.
PYMT_STAT_OVRDN_RSN_CD VARCHAR2 (30)
Payment Status Overridden Reason.
PYMT_STAT_PRR_TO_OVRD_CD VARCHAR2 (30)
Payment Satus Prior to Override.
BUSINESS_GROUP_ID NUMBER (15)
Foreign Key to HR_ORGANIZATION_UNITS
PRY_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column.
PRY_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield segment column.
PRY_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.
ELEMENT_ENTRY_VALUE_ID NUMBER

To capture the element entry created by the process
Query Text

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


SELECT PRTT_RMT_APRVD_FR_PYMT_ID
,      PRTT_REIMBMT_RQST_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      APPRVD_FR_PYMT_NUM
,      ADJMT_FLAG
,      APRVD_FR_PYMT_AMT
,      PYMT_STAT_CD
,      PYMT_STAT_RSN_CD
,      PYMT_STAT_OVRDN_RSN_CD
,      PYMT_STAT_PRR_TO_OVRD_CD
,      BUSINESS_GROUP_ID
,      PRY_ATTRIBUTE_CATEGORY
,      PRY_ATTRIBUTE1
,      PRY_ATTRIBUTE2
,      PRY_ATTRIBUTE3
,      PRY_ATTRIBUTE4
,      PRY_ATTRIBUTE5
,      PRY_ATTRIBUTE6
,      PRY_ATTRIBUTE7
,      PRY_ATTRIBUTE8
,      PRY_ATTRIBUTE9
,      PRY_ATTRIBUTE10
,      PRY_ATTRIBUTE11
,      PRY_ATTRIBUTE12
,      PRY_ATTRIBUTE13
,      PRY_ATTRIBUTE14
,      PRY_ATTRIBUTE15
,      PRY_ATTRIBUTE16
,      PRY_ATTRIBUTE17
,      PRY_ATTRIBUTE18
,      PRY_ATTRIBUTE19
,      PRY_ATTRIBUTE20
,      PRY_ATTRIBUTE21
,      PRY_ATTRIBUTE22
,      PRY_ATTRIBUTE23
,      PRY_ATTRIBUTE24
,      PRY_ATTRIBUTE25
,      PRY_ATTRIBUTE26
,      PRY_ATTRIBUTE27
,      PRY_ATTRIBUTE28
,      PRY_ATTRIBUTE29
,      PRY_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      ELEMENT_ENTRY_VALUE_ID
FROM BEN.BEN_PRTT_RMT_APRVD_FR_PYMT_F;

Dependencies

[top of page]

BEN.BEN_PRTT_RMT_APRVD_FR_PYMT_F does not reference any database object

BEN.BEN_PRTT_RMT_APRVD_FR_PYMT_F is referenced by following:

SchemaAPPS
SynonymBEN_PRTT_RMT_APRVD_FR_PYMT_F
TriggerBEN_PRTT_RMT_APRVD_FR_PYMT_WHO