Skip to main content
Aria Knowledge Central

Snowflake VM Object: Plans

► 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
  • Was this article helpful?