Skip to main content
Aria Knowledge Central

Snowflake VM Object: Plan Instances

► Plan Instances

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_INSTANCE_NO NUMBER The Aria facing unique identifier for a plan_instance
CLIENT_PLAN_INSTANCE_ID TEXT The occurrence (instance) of a plan for the referenced data
MASTER_PLAN_INSTANCE_NO NUMBER The Aria facing unique identifier for an master plan instance
MASTER_CLIENT_PLAN_INSTANCE_ID TEXT The client facing unique identifier for an master plan instance
PARENT_PLAN_INSTANCE_NO NUMBER the parent_plan_instance_no for the referenced record
PARENT_CLIENT_PLAN_INSTANCE_ID TEXT the parent_client_plan_instance_id for the referenced record
ACCOUNT_NO NUMBER The account number related to the customer referenced
USERID TEXT The userid for login related to the customer referenced
CLIENT_ACCOUNT_ID TEXT The clients unique identified for account related to the customer referenced
PLAN_NO NUMBER The Aria facing unique identifier for a plan 
CLIENT_PLAN_ID TEXT The client facing unique identifier for a plan
PLAN_UNITS NUMBER the plan_units for the referenced record
LAST_BILL_DATE DATE the last_bill_date for the referenced record
NEXT_BILL_DATE DATE the next_bill_date for the referenced record
LAST_BILL_THROUGH_DATE DATE the last_bill_through_date for the referenced record
LAST_ARREARS_BILL_THROUGH_DATE DATE the last_arrears_bill_through_date for the referenced record
LAST_ARREARS_RECURRING_BILL_THROUGH_DATE DATE the last_arrears_recurring_bill_through_date for the referenced record
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data
UPDATED_TSTAMP TIMESTAMP_NTZ The original source system updated timestamp for the referenced data
STATUS_NO NUMBER The clients status was updated at the timestamp for the customer referenced
STATUS_TSTAMP TIMESTAMP_NTZ The clients status was updated at the timestamp for the customer referenced
TERMINATED_TSTAMP TIMESTAMP_NTZ the terminated_tstamp for the referenced record
PROVISIONED_TSTAMP TIMESTAMP_NTZ the provisioned_tstamp for the referenced record
RATE_SCHEDULE_NO NUMBER the rate_schedule_no for the referenced record
CLIENT_RATE_SCHEDULE_ID TEXT the client_rate_schedule_id for the referenced record
CREATED_RECEIPT_ID TEXT the created_receipt_id for the referenced record
DESCRIPTION TEXT The detailed description related to the referenced data
PURCHASE_ORDER_NUMBER TEXT The aria facing unique identifier for a purchase order
IS_USAGE_POOLING_ENABLED BOOLEAN A True or False indicator showing if the record has usage pooling enabled
USAGE_POOLING_COUNTER NUMBER the usage_pooling_counter for the referenced record
PROMOTION_CODE TEXT the promotion_code for the referenced record
BILL_LAG_DAYS NUMBER the bill_lag_days for the referenced record
BILL_DAY NUMBER the bill_day for the referenced record
DUNNING_STATE NUMBER the dunning_state for the referenced record
DUNNING_STEP NUMBER the dunning_step for the referenced record
DUNNING_DEGRADE_DATE DATE the dunning_degrade_date for the referenced record
USAGE_ACCUMULATION_RESET_MONTHS NUMBER the usage_accumulation_reset_months for the referenced record
USAGE_ACCUMULATION_RESET_MONTHS_RENEWAL_OPTION NUMBER the usage_accumulation_reset_months_renewal_option for the referenced record
USAGE_ACCUMULATION_RESET_COUNTER NUMBER the usage_accumulation_reset_counter for the referenced record
PRODUCT_FIELDS VARIANT An embedded one to many JSON subrecord related to product fields
CUSTOM_RATES VARIANT An embedded one to many JSON subrecord related to custom rates
SERVICE_DETAILS VARIANT An embedded one to many JSON subrecord related to service details
BILLING_GROUP_NO NUMBER The designated billing group number for the referenced data
CLIENT_BILLING_GROUP_ID TEXT the client_billing_group_id for the referenced record
DUNNING_GROUP_NO NUMBER the dunning_group_no for the referenced record
CLIENT_DUNNING_GROUP_ID TEXT the client_dunning_group_id for the referenced record
RESPONSIBILITY_LEVEL_NO NUMBER the responsibility_level_no for the referenced record
RESPONSIBLE_PLAN_INSTANCE_NO NUMBER the responsible_plan_instance_no for the referenced record
RESPONSIBLE_CLIENT_PLAN_INSTANCE_ID TEXT the responsible_client_plan_instance_id for the referenced record
SURCHARGES VARIANT An embedded one to many JSON subrecord related to surcharges
BALANCE NUMBER The clients balance owed on their account for the customer referenced
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

CUSTOM_RATES PLAN_INSTANCES VM_PI_CUSTOM_RATES
PRODUCT_FIELDS PLAN_INSTANCES VM_PI_PF_VALUES
PRODUCT_FIELDS PLAN_INSTANCES VM_PI_PRODUCT_FIELDS
SERVICE_DETAILS PLAN_INSTANCES VM_PI_SERVICE_DETAILS
SURCHARGES PLAN_INSTANCES VM_PI_SURCHARGES
  • Was this article helpful?