Sample data for invoice_line_item table

Usage

invoice_line_item_test_data

id: the primary key
service_identifier: either a redcap project ID, or redcap username
service_type_code: a numeric code that uniquely identifies the service_type
service_instance_id: a numeric code that uniquely identifies the service_instance
ctsi_study_id: CSBT's unique identifier for a service
name_of_service: name of the service
name_of_service_instance: name of the study
other_system_invoicing_comments: additional invoice information, either project url, or sponsor and pi
price_of_service: price of the service, in US dollars
qty_provided: quantity provided
amount_due: amount due, in US dollars
fiscal_year: fiscal year of the invoice
month_invoiced: month of the invoice
pi_last_name: last name of the person invoiced
pi_first_name: first name of the person invoiced
pi_email: email of the person invoiced
gatorlink: gatorlink of the person invoiced
reason: reason for the invoice
status: status of the invoice
sender: character: message sender, typically an email address
recipient: character: message recipient, typically an email address
date_sent: POSIXct: date CTSI sent the message
date_received: POSIXct: date CTSIT received the email
script_name: character: the script that created this record
created: created at timestamp
updated: updated at timestamp