DW_NS_subscriptionPlan

This table has the details of the available subscription plans with associated attributes like subscription term, renewal methods etc.

Details

Module:

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
id	NUMBER	38	0	True
SOURCE_RECORD_ID	VARCHAR2	128			This column is for Oracle Internal use only. This is source record id column.
advancerenewalperiodnumber	NUMBER	38	0		Advance Renewal Period
advancerenewalperiodunit	VARCHAR2	32			Advance Renewal Period Unit	DW_NS_subscriptiontermunit_D	id
autorenewal	VARCHAR2	16			Automatically Initiate Renewal Process
class	NUMBER	38	0		Class	DW_NS_classification_D	id
createddate	TIMESTAMP				Created Date
defaultrenewalmethod	VARCHAR2	64			Default Renewal Method
defaultrenewalplan	NUMBER	38	0		Default Renewal Subscription Plan	DW_NS_subscriptionPlan_D	id
defaultrenewalterm	NUMBER	38	0		Default Renewal Term	DW_NS_subscriptionTerm_D	id
defaultrenewaltrantype	VARCHAR2	16			Default Renewal Transaction Type
department	NUMBER	38	0		Department	DW_NS_department_D	id
description	VARCHAR2	999			Description
displayname	VARCHAR2	999			Display Name
fullname	VARCHAR2	999			Full Name
includechildren	VARCHAR2	16			Include Children
initialterm	NUMBER	38	0		Initial Term	DW_NS_subscriptionTerm_D	id
isinactive	VARCHAR2	16			Inactive
itemid	VARCHAR2	512			Subscription Plan Name
itemtype	VARCHAR2	32			Item Type	DW_NS_ITEMTYPE_D	id
lastmodifieddate	TIMESTAMP				Last Modified Date
location	NUMBER	38	0		Location	DW_NS_location_D	id