Entity Planned Activity Detail

DescriptionAn activity that is intended to occur or start at some point in the context of a particular study.

For example:
Pregnancy tests are planned for study subjects who are females of childbearing potential.

Attributes
Activity NmActivity Nm
Activity SkActivity Sk
Agent Administration Care Setting Type Code SkAgent Administration Care Setting Type Code Sk
Blinded DescrBlinded Descr
Category Code SkCategory Code Sk
Comment TxtComment Txt
Description TxtDescription Txt
Duration QtyDuration Qty
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Identification NumIdentification Num
Interruptible IndInterruptible Ind
Load Info SkLoad Info Sk
Purpose TxtPurpose Txt
Reason Code SkReason Code Sk
Repeat Duration QtyRepeat Duration Qty
Repeat Frequency Code SkRepeat Frequency Code Sk
Repeat Frequency RatioRepeat Frequency Ratio
Repeat Quantity RangeRepeat Quantity Range
Source Code SkSource Code Sk
Status Change Reason Code SkStatus Change Reason Code Sk
Status Code SkStatus Code Sk
Status DtStatus Dt
Study Accrual Threshold PctStudy Accrual Threshold Pct
Study Day Range QtyStudy Day Range Qty
Study Focus IndStudy Focus Ind
Study Site Accrual Threshold PctStudy Site Accrual Threshold Pct
Subcategory Code SkSubcategory Code Sk
Tenant SkTenant Sk
Valid From TsValid From Ts
Valid To TsValid To Ts

Relationship
Planned Activity Detail_Activity_FKPlanned Activity Detail_Activity_FK

Primary Key
Planned Activity Detail PKPlanned Activity Detail PK

Dependencies
 
 
 

Reverse Dependencies
 

Attribute Details

 Activity Nm
DescriptionThe text description of an activity within a clinical trial or study.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Activity Sk
DescriptionSurrogate key for the anchor entity.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Agent Administration Care Setting Type Code Sk
DescriptionIdentifies the level of healthcare (care setting) required by the subject based on the nature of the procedure.

For example:
Some, but not all, agents given as inpatient
All agents given as inpatient
All agents given as outpatient
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blinded Descr
DescriptionThe textual representation of the planned activity from the point of view of a blinded participant (study subject or study investigator).

For example:
During the second treatment epoch of a study, Arms A and B are still blinded and Arm C is no longer blinded. So, Arm A and B must have identical blinded descriptions.

In a study with 3 arms, Arm 1: standard vaccine given in three shots at 2 months, 5 months, and 12 months of age; Arm 2: new vaccine given in three shots at 2 months, 5 months, and 12 months of age; Arm 3: new vaccine given in two shots at 2 months and 5 months of age. Subjects assigned to the third arm are unblinded at some point during 5 months and 12 months. By the time of the Third Shot Epoch, the "Arm 3/Third Shot" activity can be called by this, its unblinded name. However, the "Arm 1/Third Shot" and "Arm2/Third Shot" activities still need blinded names. Both these activities would have the blinded name (something like) "3-shot Arm/Third Shot".
Data TypeStandards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Category Code Sk
DescriptionClassification of activities.

For example:
In the case where Category Code = "anti-cancer treatment", the Sub Category Code may = "radiotherapy" and the Name Code may = "external beam radiotherapy".
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Comment Txt
DescriptionAdditional description of the activity.

For example:
Guidance on how to perform the observation.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Description Txt
DescriptionThe textual representation of the activity.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Duration Qty
DescriptionThe intended period of time for the planned activity as defined by the study.

For example:
6 weeks may be the planned duration for a composite activity that represents the activities occurring during an epoch on arm A.
Data TypeStandards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Identification Num
DescriptionA unique symbol that establishes identity of an activity.

For example:
12345 is the identifier for a substance administration
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Interruptible Ind
DescriptionSpecifies whether the planned activity is interruptible by asynchronous events. This may only be useful for Planned Subject Activity Groups or administrative activities.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Purpose Txt
DescriptionThe reason for the planned activity.

For example:
Treating a disease (treatment)
Determining eligibility for a study (screening)

Per GForge Tracker item 31402, this attribute is redundant and we're deprecating it in favor of the existing Activity Reason Code.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Reason Code Sk
DescriptionA coded value specifying the motivation, cause, or rationale of an activity.

For example:
Routine requirement
Drug reaction
Infectious disease reporting requirement
On patient request
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Repeat Duration Qty
DescriptionThe period of time over which the activity is repeated.
Data TypeStandards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Repeat Frequency Code Sk
DescriptionThe repeating frequency with which the treatment is to be administered. It is similar to the frequency and SIG code tables used in order entry systems.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Repeat Frequency Ratio
DescriptionA ratio representing the number of occurrences of a planned activity within a given time period.

For example:
Once per 12 hours
2 times per day
Data TypeStandards - Data Domains.ddm/Data Domains/Ratio [FLOAT(5)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Repeat Quantity Range
DescriptionAn integer falling within minimum and maximum bounds that specifies how many times the planned activity occurs. If the frequency is more than once a day, this is still interpreted per time, for example, BID for 5 days is 10 repeats.
Data TypeStandards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Status Change Reason Code Sk
DescriptionSpecifies why the status has changed.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Status Code Sk
DescriptionIndicates the phase in the lifecycle of the activity as part of a global library.

For example:
Draft New
Released
Retired
Archived
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Status Dt
DescriptionThe date and time the status for an activity as part of a study or clinical trial is defined.
Data TypeStandards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Study Accrual Threshold Pct
DescriptionAn integer specifying a percentage of target accrual for a study, which when reached triggers a notification.

For example:
75% or 90% of the target accrual number.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Study Day Range Qty
DescriptionThe relative timing for a planned activity expressed as the number of days offset from the study-defined reference activity (for example, date of registration, start of treatment) for a particular subject, study subject or experimental unit.

For example:
Day 1
Days 10-20
Data TypeStandards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Study Focus Ind
DescriptionSpecifies whether the activity is a key investigational activity for a study. If a study has study agents, one or more of the study activities will presumably use the agent and have this indicator set to true.

For example:
A study focused on investigating the effectiveness of a drug will flag the substance administration of the drug or a study focused on determining the average blood pressure of a certain population will flag the blood pressure observation.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Study Site Accrual Threshold Pct
DescriptionAn integer specifying a percentage of target accrual at a particular study site, which when reached triggers a notification.

For example:
75% or 90% of the target accrual number.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Subcategory Code Sk
DescriptionSpecifies a subdivision within a larger category of activities.

For example:
Chemotherapy
Radiotherapy
Hormonal therapy
Alternative therapy
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Planned Activity Detail_Activity_FK
Is Identifying Relationshiptrue
Child TablePlanned Activity Detail
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableActivity
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Planned Activity Detail PK
Key AttributeActivity Sk
Key AttributeValid From Ts