Reference Guide > TDV and Business Directory System Tables > SYS_DEPLOYMENT_PLANS
 
SYS_DEPLOYMENT_PLANS
The SYS_DEPLOYMENT_PLANS system table provides a list of deployment plan definitions. Users see no rows unless they have the ACCESS_TOOLS right. Users with this right can see all rows.
Note: Unlike most system tables, this table is under /system/deployment in the Studio resource tree.
Column
TDV
JDBC Data Type
Nullable
Description
DEPLOYMENT_PLAN_ID
INTEGER
 
Identifier for the deployment plan.
DEPLOYMENT_PLAN_NAME
VARCHAR(255)
 
Name of the deployment plan.
TARGET_SITE_NAME
VARCHAR(255)
 
Name of the target site.
SOURCE_SITE_NAME
VARCHAR(255)
 
Name of the source site.
DEFINITION
VARCHAR(2147483647)
 
JSON string defining the deployment plan.
ANNOTATION
VARCHAR(2147483647)
 
Annotation.
STATUS
VARCHAR(2147483647)
 
Impact status.
OWNER
VARCHAR(2147483647)
 
Owner of the deployment plan.
CREATE_TIME
BIGINT
 
Deployment plan creation time.
MODIFY_TIME
BIGINT
 
Time of last plan modification.
MODIFY_USER
VARCHAR(2147483647)
 
Name of last person to modify the plan.