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

TABLE: PV.PV_PARTNER_PROGRAM_B

Object Details
Object Name: PV_PARTNER_PROGRAM_B
Object Type: TABLE
Owner: PV
FND Design Data: TablePV.PV_PARTNER_PROGRAM_B
Subobject Name:
Status: VALID


PV_PARTNER_PROGRAM_B is used to store all the partner program details. Partner programs are of two kinds - Program, and Membership - which is determined by PROGRAM_LEVEL_CODE column. Partner programs follow hierarchical model. Programs are at parent level, and Memberships roll into these Programs.
Vendor creates Partner Programs in which Partner, and VAD users can enroll into. Basically, these programs determine
a) what kind of requirements partner/VAD users should have inorder to qualify for enrollment,
b) questionnaire information that needs to be filled for enrollment,
c) contracts that need to be signed for enrollment,
d) payment and eligibility details in different geographies,
e) benefits an user gets after enrollment,
f) enrollment characteristics like duration, open period for enrollment, etc.
g) program description.
Each program is for different type of partners, and PROGRAM_TYPE_ID determines it.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PV_PARTNER_PROGRAM_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROGRAM_ID
PV_PARTNER_PROGRAM_B_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_RULE_ID
PV_PARTNER_PROGRAM_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROGRAM_PARENT_ID
PV_PARTNER_PROGRAM_B_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROGRAM_OWNER_RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
PROGRAM_ID NUMBER
Yes Unique identifier for the Program
OBJECT_VERSION_NUMBER NUMBER (9) Yes This column is used for locking purposes
CUSTOM_SETUP_ID NUMBER
Yes Foreign Key to AMS_CUSTOM_SETUPS_B
PROGRAM_PARENT_ID NUMBER

Hold Parent Program ID if it is a child program.
PROGRAM_OWNER_RESOURCE_ID NUMBER
Yes Hold information about Program Owner. Foreign Key to JTF_PRODUCTS_RESOURCE_EXTNS.
PROGRAM_TYPE_ID NUMBER
Yes Foreign Key to PV_PARTNER_PROGRAM_TYPE_B
PROGRAM_LEVEL_CODE VARCHAR2 (30) Yes Hold information about Program Level, e.g. PROGRAM, MEMBERSHIP.
PROGRAM_STATUS_CODE VARCHAR2 (30) Yes Hold status ( i.e. NEW, PENDING APPROVAL, REJECTED, APPROVED etc. ) of each Program. Will have foreign key to FND_LOOKUP table.
ENABLED_FLAG VARCHAR2 (1) Yes Hold information about enabled/disabled status about the partner program.
PROGRAM_START_DATE DATE
Yes Program Start Date
PROGRAM_END_DATE DATE
Yes Program End Date
PROCESS_RULE_ID NUMBER
Yes Determines linkage to the Qualification Attributes Rules module. Qualification attributes for each Program will be part of Attribute Management module. Foreign Key to PV_PROCESS_RULES_B.
USER_STATUS_ID NUMBER
Yes Foreign key to AMS user statuses table to show user configurable program status
MEMBERSHIP_PERIOD_UNIT VARCHAR2 (30)
Period unit for membership valid period.
MEMBERSHIP_VALID_PERIOD NUMBER

Period for a given membership fees
SUBMIT_CHILD_NODES VARCHAR2 (1)
Flag that indicates whether all the child programs need to be submited for approval automatically when the parent program gets approved
INVENTORY_ITEM_ID NUMBER

Foreign key to INV inventory, in case of memberships, as the membership is created as inventory item for order processing
INVENTORY_ITEM_ORG_ID NUMBER (32)
Organization Id in which inventory item is created - Foreign key
BUS_USER_RESP_ID NUMBER

Business User Responsibility Id that gets associated all business user enrollees in this program - Foreign key
ADMIN_RESP_ID NUMBER

Admin User Responsibility Id that gets associated all Administrator user enrollees in this program - Foreign key
NO_FEE_FLAG VARCHAR2 (1)
Waiver flag - Yes means no fee is collected for this program enrollment
QSNR_TTL_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
Indicate whether the questionnaire title should be displayed in all pages or not
QSNR_HDR_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
Indicate whether the questionnaire header should be displayed in all pages or not
QSNR_FTR_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
Indicate whether the questionnaire footer should be displayed in all pages or not
ALLOW_ENRL_WOUT_CHKLST_FLAG VARCHAR2 (1)
Whether enrollment can be allowed without checklist items being completely checked
ALLOW_ENRL_UNTIL_DATE DATE

Enrollment into the membership can be allowed until this date
CITEM_VERSION_ID NUMBER

Foreign key to IBC content items, that stores the program summary content
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Attribute category
ATTRIBUTE1 VARCHAR2 (240)
Attribute1
ATTRIBUTE2 VARCHAR2 (240)
Attribute2
ATTRIBUTE3 VARCHAR2 (240)
Attribute3
ATTRIBUTE4 VARCHAR2 (240)
Attribute4
ATTRIBUTE5 VARCHAR2 (240)
Attribute5
ATTRIBUTE6 VARCHAR2 (240)
Attribute6
ATTRIBUTE7 VARCHAR2 (240)
Attribute7
ATTRIBUTE8 VARCHAR2 (240)
Attribute8
ATTRIBUTE9 VARCHAR2 (240)
Attribute9
ATTRIBUTE10 VARCHAR2 (240)
Attribute10
ATTRIBUTE11 VARCHAR2 (240)
Attribute11
ATTRIBUTE12 VARCHAR2 (240)
Attribute12
ATTRIBUTE13 VARCHAR2 (240)
Attribute13
ATTRIBUTE14 VARCHAR2 (240)
Attribute14
ATTRIBUTE15 VARCHAR2 (240)
Attribute15
VAD_INVITE_ALLOW_FLAG VARCHAR2 (1)
Whether VAD can invite partners to join in this program. Y means VAD can invite
GLOBAL_MMBR_REQD_FLAG VARCHAR2 (1)
Whether global membership is required before subsidiary can enroll. Y means global membership is required
WAIVE_SUBSIDIARY_FEE_FLAG VARCHAR2 (1)
Waiver flag for subsidiary fees. Y means subsidiary need not pay
PREREQ_PROCESS_RULE_ID NUMBER

Determines linkage to the Prerequistes Qualification Attributes Rules module.
Query Text

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


SELECT PROGRAM_ID
,      OBJECT_VERSION_NUMBER
,      CUSTOM_SETUP_ID
,      PROGRAM_PARENT_ID
,      PROGRAM_OWNER_RESOURCE_ID
,      PROGRAM_TYPE_ID
,      PROGRAM_LEVEL_CODE
,      PROGRAM_STATUS_CODE
,      ENABLED_FLAG
,      PROGRAM_START_DATE
,      PROGRAM_END_DATE
,      PROCESS_RULE_ID
,      USER_STATUS_ID
,      MEMBERSHIP_PERIOD_UNIT
,      MEMBERSHIP_VALID_PERIOD
,      SUBMIT_CHILD_NODES
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_ORG_ID
,      BUS_USER_RESP_ID
,      ADMIN_RESP_ID
,      NO_FEE_FLAG
,      QSNR_TTL_ALL_PAGE_DSP_FLAG
,      QSNR_HDR_ALL_PAGE_DSP_FLAG
,      QSNR_FTR_ALL_PAGE_DSP_FLAG
,      ALLOW_ENRL_WOUT_CHKLST_FLAG
,      ALLOW_ENRL_UNTIL_DATE
,      CITEM_VERSION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VAD_INVITE_ALLOW_FLAG
,      GLOBAL_MMBR_REQD_FLAG
,      WAIVE_SUBSIDIARY_FEE_FLAG
,      PREREQ_PROCESS_RULE_ID
FROM PV.PV_PARTNER_PROGRAM_B;

Dependencies

[top of page]

PV.PV_PARTNER_PROGRAM_B does not reference any database object

PV.PV_PARTNER_PROGRAM_B is referenced by following:

SchemaAPPS
SynonymPV_PARTNER_PROGRAM_B