CertificationActivity

Name: Certification Activity

Type: Ancillary, Application

Modules: Cert

Description: Tracks, contains changes, activities, conditions, status of passenger certification, notifications, etc. for the Cert application.


Field	Documentation
CaId	Numeric identifier of the certification activity record.
ClientId	Numeric identifier of the client (from the Clients table).
TableCode	Code that indicates which table the activity is recorded in (e.g., C = Clients table, R = Requests table).
DecisionDate	(If applicable) Date that a decision was made on the related activity (e.g., appeal, date of the appeal verdict).
RequestDate	Date that the activity was requested (e.g., date the client requested to be interviewed).
ActivityId	Numeric identifier of the activity (from the CertificationActivityType table).
DateEntered	Date the user entered the activity request into the system.
RComments	Comments about the activity.
ApptDate	Appointment date for the activity.
ApptTime	Appointment time for the activity.
WorkerId	Numeric identifier of the case worker assigned to the case( from the CertificationWorker table).
Facility	Numeric identifier of the location or facility where the activity is to take place (from the CertificationFacilities table).
ResultCode	ID for the activity result of the activity (from the CertificationResults table).
PaidDate	Date when the payment for the activity was made.
Transport	Flag that indicates whether the client needs to be transported to the activity site.
PrintDate	Date that related documents (e.g., Expire Notifications) were printed.
CreBy	Username that created the activity (e.g., record, appeal).
CreDate	Date the record was created.
CreTime	Time the record was created. Value is in seconds from midnight.
ModBy	Username that last modified the record.
ModDate	Date the record was last modified.
ModTime	Time the record was last modified. Value is in seconds from midnight.
FundingSourceId	Funding source ID associated with the activity (from the FundingSources table).
EligFromDate	Starting date from which the client is eligible to use the funding source.
EligToDate	End date after which the client is no longer eligible to use the funding source.
ShouldPrint	Flag that indicates whether the record for the appeal should be printed.
BttFromAddress	Address from which the client is to perform or has performed bus travel training.
BttToAddress	Address to which the client is to perform or has performed bus travel training.
BttCost	Cost of the bus travel training.
BttPriorTrips	Number of trips the clients has taken before bus travel training.
BttPost1Trips	Number of trips the client has made after the first bus travel training session.
BttPost2Trips	Number of trips the client has made after the second bus travel training session.
ApptAId	Numeric identifier of the certification appointment (from the CertificationAppt table).