Snowflake VM Object: Plans

Last updated
Save as PDF

► Plans

Field	Datatype	Description
CLIENT_NO	NUMBER	CLIENT_NO uniquely identifying each unique client
IS_DELETED	BOOLEAN	Denotes a True/False as to if the referenced data has been deleted via soft delete
REF_PK	TEXT	REF_PK The PK of the ref_type concatenated with a pipe as needed within the JSON
PLAN_NO	NUMBER	The Aria facing unique identifier for a plan
CLIENT_PLAN_ID	TEXT	The client facing unique identifier for a plan
NAME	TEXT	the name for the referenced record
DESCRIPTION	TEXT	The detailed description related to the referenced data
IS_ACTIVE	BOOLEAN	A True or False indicator showing if the record is active
IS_SUPPLEMENTAL_PLAN	BOOLEAN	A True or False indicator showing if the record is a supplemental plan
IS_TEMPLATE	BOOLEAN	A True or False indicator showing if the record is a template
PRODUCT_FIELD_CATEGORIES	VARIANT	An embedded one to many JSON subrecord related to product field categories
PRORATION_INVOICE_TIMING_CD	NUMBER	the proration_invoice_timing_cd for the referenced record
STATEMENT_TEMPLATE_NO	NUMBER	the statement_template_no for the referenced record
CLIENT_STATEMENT_TEMPLATE_ID	TEXT	the client_statement_template_id for the referenced record
NOTIFICATION_TEMPLATE_GROUP_NO	NUMBER	the notification_template_group_no for the referenced record
CLIENT_NOTIFICATION_TEMPLATE_GROUP_ID	TEXT	the client_notification_template_group_id for the referenced record
CREDIT_NOTE_TEMPLATE_NO	NUMBER	the credit_note_template_no for the referenced record
CLIENT_CREDIT_NOTE_TEMPLATE_ID	TEXT	the client_credit_note_template_id for the referenced record
CREDIT_MEMO_TEMPLATE_NO	NUMBER	the credit_memo_template_no for the referenced record
CLIENT_CREDIT_MEMO_TEMPLATE_ID	TEXT	the client_credit_memo_template_id for the referenced record
REBILL_TEMPLATE_NO	NUMBER	the rebill_template_no for the referenced record
CLIENT_REBILL_TEMPLATE_ID	TEXT	the client_rebill_template_id for the referenced record
HAS_PLAN_CANCELLATION_FEE	BOOLEAN	the has_plan_cancellation_fee for the referenced record
CANCELLATION_MINIMUM_MONTHS	NUMBER	the cancellation_minimum_months for the referenced record
SURCHARGES	VARIANT	An embedded one to many JSON subrecord related to surcharges
SERVICE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to service details
PLAN_RATE_SCHEDULES	VARIANT	An embedded one to many JSON subrecord related to plan_rate_schedules
NONSUBSCRIPTION_OFFERING_BUNDLE_TYPE_CD	TEXT	the nonsubscription_offering_bundle_type_cd for the referenced record
NONSUBSCRIPTION_OFFERING_INDIVIDUALS	VARIANT	An embedded one to many JSON subrecord related to nonsubscription offering individuals
NONSUBSCRIPTION_OFFERING_GROUP	VARIANT	An embedded one to many JSON subrecord related to nonsubscription offering group
AVAILABLE_NONSUBSCRIPTION_OFFERING_SCOPE_IND	NUMBER	the available_nonsubscription_offering_scope_ind for the referenced record
AVAILABLE_NONSUBSCRIPTION_OFFERINGS	VARIANT	An embedded one to many JSON subrecord related to available nonsubscription offerings
DEFAULT_CURRENCY_CD	TEXT	the default_currency_cd for the referenced record
INITIAL_FREE_PERIOD_QUANTITY	NUMBER	the initial_free_period_quantity for the referenced record
INITIAL_FREE_PERIOD_TYPE_NO	NUMBER	the initial_free_period_type_no for the referenced record
INITIAL_PLAN_INSTANCE_STATUS_NO	NUMBER	the initial_plan_instance_status_no for the referenced record
PLAN_INSTANCE_STATUS_ROLLOVER_PERIOD_QUANTITY	NUMBER	the plan_instance_status_rollover_period_quantity for the referenced record
PLAN_INSTANCE_STATUS_ROLLOVER_PERIOD_TYPE_NO	NUMBER	the plan_instance_status_rollover_period_type_no for the referenced record
ROLLOVER_PLAN_INSTANCE_STATUS_NO	NUMBER	the rollover_plan_instance_status_no for the referenced record
ROLLOVER_PLAN_NO	NUMBER	the rollover_plan_no for the referenced record
CLIENT_ROLLOVER_PLAN_ID	TEXT	the client_rollover_plan_id for the referenced record
ROLLOVER_PLAN_PERIOD_QUANTITY	NUMBER	the rollover_plan_period_quantity for the referenced record
ROLLOVER_PLAN_PERIOD_TYPE_NO	NUMBER	the rollover_plan_period_type_no for the referenced record
CONTRACT_COMPLETION_ROLLOVER_PLAN_NO	NUMBER	the contract_completion_rollover_plan_no for the referenced record
CLIENT_CONTRACT_COMPLETION_ROLLOVER_PLAN_ID	TEXT	the client_contract_completion_rollover_plan_id for the referenced record
CONTRACT_COMPLETION_ROLLOVER_RATE_SCHEDULES	VARIANT	An embedded one to many JSON subrecord related to contract completion rollover rate schedule
LOCALE_DETAILS	VARIANT	An embedded one to many JSON subrecord related to the records locale
PRODUCT_FIELD_ASSIGNMENTS	VARIANT	An embedded one to many JSON subrecord related to product field assignments
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data
CREATED_BATCH_ID	NUMBER	The aria facing creation batch id assigned upon landing for the referenced data
CREATED_BATCH_TSTAMP	TIMESTAMP_NTZ	The aria facing batch timstamp assigned upon landing for the referenced data, showing its creation in snowflake
UPDATED_BATCH_ID	NUMBER	The aria facing update batch id assigned upon landing for the referenced data
UPDATED_BATCH_TSTAMP	TIMESTAMP_NTZ	The aria facing batch timstamp assigned upon landing for the referenced data, showing its update in snowflake
Child Views
Variant	Source Table	Child View Name
AVAILABLE_NONSUBSCRIPTION_OFFERINGS	PLANS	VM_PLAN_AVAILABLE_NONSUBSCRIPTION_OFFERINGS
CONTRACT_COMPLETION_ROLLOVER_RATE_SCHEDULES	PLANS	VM_PLAN_CONTRACT_COMPLETION_ROLLOVER_RATE_SCHEDULES
LOCALE_DETAILS	PLANS	VM_PLAN_LOCALE_DETAILS
NONSUBSCRIPTION_OFFERING_GROUP	PLANS	VM_PLAN_NONSUBSCRIPTION_OFFERING_GROUPS
NONSUBSCRIPTION_OFFERING_GROUP	PLANS	VM_PLAN_NSOG_PLAN_NONSUBSCRIPTION_OFFERINGS_NONSUBSCRIPTION_OFFERING_SCHEDULE_ASSIGNMENTS
NONSUBSCRIPTION_OFFERING_INDIVIDUALS	PLANS	VM_PLAN_NONSUBSCRIPTION_OFFERING_INDIVIDUALS
PLAN_RATE_SCHEDULES	PLANS	VM_PLAN_PLAN_RATE_SCHEDULES
PRODUCT_FIELD_ASSIGNMENTS	PLANS	VM_PLAN_PFA_VALUES
PRODUCT_FIELD_ASSIGNMENTS	PLANS	VM_PLAN_PFA_VALUE_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS	PLANS	VM_PLAN_PRODUCT_FIELD_ASSIGNMENTS
PRODUCT_FIELD_CATEGORIES	PLANS	VM_PLAN_PRODUCT_FIELD_CATEGORIES
SERVICE_DETAILS	PLANS	VM_PLAN_SD_USAGE_THRESHOLDS
SERVICE_DETAILS	PLANS	VM_PLAN_SD_UT_LEVELS
SERVICE_DETAILS	PLANS	VM_PLAN_SERVICE_DETAILS
SURCHARGES	PLANS	VM_PLAN_SURCHARGES