Skip to content Learn about the access keys available for Metadata.NSW
A NSW Government website
Metadata.NSW (beta)

Definition

'The Child Protection Reports - Longitudinal Data Asset' has been developed to support internal and/or external research, evaluation and modelling. It is a continuation of the historic 'Overtime' file which was historically developed from quarterly and annual extracts provided to FACSIAR by the Information Management team and processed using SPSS scripts. 

The primary purpose and use cases of the 'The Child Protection Reports - Longitudinal Data Asset' are:

  • Where historic data is required beyond what is available in the 'Child Protection Reports -  Base Data Asset' or the 'Client Information Warehouse (CIW)'. This includes records from ChildStory, KiDS and other previous case management systems as well as paper based records.
  • Where the user requires data as recorded according to business and counting rules of the time around which the record was created. For example, the district out of which case work activities were carried out will be recorded at the time of the record creation. In contrast, data from the CIW Production Environment and recent FAP loads will record the historic district according to current definitions.
  • The asset contains a subset of the fields currently available in the CIW report builder and the Child Protection Reports Base Data Asset. The included dimensions have been selected based on anticipates usage needs. The full list of fields have not been included to minimise the complexity of the asset. 

Due to the processing of the file, records and resulting counts are expected to vary from those in the Child protection Reports - Base Data Asset. The Longitudinal asset should therefore not be used for internal reporting purposes. 

The asset is stored in the table `fdp-child-protection-prod.child_protection_pii_bdm.cp_longitudinal` in the Google Cloud Platform Federated Analytics Platform and includes data back to 1987.

Data is incorporated from two sources:

  1. Existing longitudinal file containing records to 30 June 2019 coming from data manually provided by IM. 

  2. Bi Annual data from CIW extracts, appended onto the existing file using R and SPSS scripts. The processing of data is currently carried out on local machines, and is int he process of being rewritten in tools hosted on the Federated Analytics Platform. 

 

Data source details

Path name Data Element Definition Data Type Format
child_story_id Person: ChildStory Identifier, A-N(8)

Internal Department of Communities and Justice (DCJ) Person identifier from ChildStory. 


Specific Information:

Known data quality issues: A number of CYP who have a legacy ID currently do not have a ChildStoryID. This is because some CYP were identified as being duplicated at some point in time there records were merged in the course system and only one ID was kept.
KiDS concordance: All client records existing upon the implementation of Childstory were assigned a Childstory ID during the data conversion process.
 

CHARACTERSTRING A-N(8)
legacy_kids_person_number Person: KiDS Number, Identifier X(14)

A person's internal Department of Communities and Justice (DCJ) Person Identifier from the legacy KiDS system.


Specific Information:

Known data quality issues: Will only exist for records created prior to implementation of Childstory.
KiDS concordance: Allows for matching of clients to extracts created prior to ChildStory
 

CHARACTERSTRING X(14)
finyear Record: Financial Year, YYYY-YY

The fiscal year or twelve month accounting period, which in Australia commences 1 July of a given calendar year and ends 30 June of the following calendar year relating to a report.

NUMBERSTRING N(4)-N(2)
n1ContactsReceivedAtHelpline Service Event: Helpline Contact, N1 Code NX

Indicator that a contact is made with the helpline, as represented by a code


Specific Information:

Known data quality issues: Only records with a value of 1B have been included in this data extract. Only available from 2017/18 onwards.

ALPHANUMERICSTRING NX
n2ContactsconcernCYPandnonCYP Service Event: Helpline Contact, N2 Code NX

Reason contact is made with the helpline, as represented by a code


Specific Information:

Framework dimension to indicate the primary contact reason. i.e. is this a contact to the helpline relating to a concern about a CYP, or contact for another reason.

ALPHANUMERICSTRING NX
n3HelplineAssessmentOutcome Service Event: Helpline Assessment Outcome, Code NX

The outcome of the Helpline Screening and Response Priority Tools (SCRPT) assessment, as represented by a code.


Specific Information:

Framework dimension to indicate the outcome of the helpline SCRIPT assessment.

ALPHANUMERICSTRING NX
n4TriageDecision Service Event: Triage Decision Outcome, Code NX(N)

The outcome of the triage decision at the CSC (or helpline if the report is closed at the helpline), as represented by a code


Specific Information:

Framework dimension to indicate the outcome of the triage decision at the CSC (or helpline if the report is closed at the helpline)

ALPHANUMERICSTRING NX(N)
n5OutcomeOfFieldAssessment Service Event: Field Assessment Outcome, Code NX(N)

The outcome of a field assessment, as represented by a code.
 


Specific Information:

Framework dimension to indicate field assessment outcome.

ALPHANUMERICSTRING NX(N)
pseudo_report_flag You don't have permission to see this Data Element. -
Specific Information:

A pseudo report is added when additional children are 'discovered' during a field assessment and CIW creates a report for these children based on the report of the original child for whom the field assessment was conducted.

- -
rosh_flag You don't have permission to see this Data Element. -
Specific Information:

Flag indicates if the report meets the threshold for Risk of Significant Harm (ROSH) upon applying the screening tool at the Child Protection Helpline

- -
primary_helpline_assessed_issue Assessment: Helpline Primary Issue, Label X(200)

Issue identified at Helpline assessment that has been flagged as primary by the Helpline caseworker, represented by a label


Specific Information:

Issue identified at Helpline assessment that has been flagged as primary by the Helpline caseworker.

CHARACTERSTRING X(200)
primary_helpline_assessed_issue_grouped Assessment: Helpline Primary Issue, Grouped Label X(50)

Issue assessed as primary by a Helpline caseworker, represented by a group label


Specific Information:

CIW derived higher level grouping of PrimaryHelplineAssessedIssue

CHARACTERSTRING X(50)
primary_field_assessment_assessed_issue Assessment: Helpline Primary Issue, Label X(200)

Issue identified at Helpline assessment that has been flagged as primary by the Helpline caseworker, represented by a label


Specific Information:

Issue identified at field assessment that has been flagged as primary by the caseworker.

CHARACTERSTRING X(200)
primary_field_assessment_assessed_issue_grouped Assessment: Helpline Primary Issue, Grouped Label X(50)

Issue assessed as primary by a Helpline caseworker, represented by a group label


Specific Information:

CIW derived higher level grouping of Issue identified at field assessment that has been flagged as primary by the caseworker. Grouping based on matched data in PrimaryHelplineAssessedIssue

CHARACTERSTRING X(50)
primary_field_assessment_assessed_issue_actual_harmor_riskof_harm Assessment: Field Assessment - Actual Harm or Risk of Harm, ROSH Label X(20)

Substantiated harm or risk for a child or young person, made by a caseworker during the field assessment process (part of the substantiation questions), as represented by a label.


Specific Information:

Part of the substantiation questions entered by caseworker during the field assessment process.

CHARACTERSTRING X(20)
primary_field_assessment_assessed_issue_harm_type Assessment: Field Harm Type, Group Label X(30)

The type of harm identified in the primary assessed issue on the field assessment, as represented by a grouped label.


Specific Information:

Grouping of field assessment issues following substantiation

CHARACTERSTRING X(30)
safety_outcome You don't have permission to see this Data Element. -
Specific Information:

Outcome of first (primary) safety assessment attached to the contact

- -
final_risk_level Assessment: Risk Level, Label X(22)

The level of risk determined in an assessment, as represented by a label.


Specific Information:

Outcome of the first (primary) risk assessment or alternate assessment attached to the contact. If a CYP has both a RA and an AA the AA takes precedence.

CHARACTERSTRING X(22)
final_response_priority Service Event: Final Response Priority, Label X(40)

Final response priority determined by the Response Priority Tool at Helpline in relation to the report, as represented by a label


Specific Information:

Final response priority determined by the Response Priority Tool at Helpline in relation to the report

ALPHANUMERICSTRING X(40)
district Service Event: NSW Department of Communities and Justice District, Label X(40)

The District of the business unit where the report was sent by Helpline, as represented by a label.


Specific Information:

The District attached to the furthest stage of the child protection framework that has been progressed to on the following order from earliest to furthest: Contact, Helpline, Transfer, Triage, Case, Field Assessment

CHARACTERSTRING X(40)
internal_organisation_business_unit Organisation: Internal Business Unit, label X(50)

An Internal Business Unit that provides services and/or care, as represented by a label


Specific Information:

The Business Unit (including CSCs) attached of the furthest stage of the child protection framework that has been progressed to on the following order from earliest to furthest: Contact, Helpline, Transfer, Triage, Case, Field Assessment

CHARACTERSTRING X(50)
residential_address_postcode Person: Australian Postcode, Code NNNN

The numeric descriptor for an Australian postal delivery area, aligned with locality, suburb or place for the address of a person.


Specific Information:

Postcode recorded where child's residential address is known

NUMBERSTRING NNNN
gender You don't have permission to see this Data Element. -
Specific Information:

Gender of person record at the time of extract

- -
dob Person: Date of birth, DDMMYYYY

The date of birth of the person, expressed as DDMMYYYY.

DATE DDMMYYYY
aboriginal_status_fa_cs_grouped Person: Indigenous Status, Grouped Label X(14)

Aboriginal Status, as represented by a grouped label


Specific Information:

Aboriginal Status at the time of extract

CHARACTERSTRING X(14)
countryof_birth You don't have permission to see this Data Element. -
Specific Information:

Known data quality issues: Poor data recording

- -
preferred_language Person: Preferred Language, Label X(50)

The preferred language spoken by a given client, represented by a label.


Specific Information:

Known data quality issues: Poor data recording

CHARACTERSTRING X(50)
primary_cultural_background Person: Culturally and Linguistically Diverse (CALD) Background, Text X(50)

Self-enumeration of cultural and linguistic background, based on whether or not one was born in a country other than Australia, has a cultural background other than Australian, or can speak languages other than English, by respondents entering "free text".


Specific Information:

Known data quality issues: Poor data recording

ALPHANUMERICSTRING X(50)
disability_flag Person: Disability Status, Label X(20)

An indicator of whether a person has a disability


Specific Information:

Whether person has at least one recoded disability type
Known data quality issues: Poor data recording and likely subjective Not entered only introduced in 2019/20 snapshot. Recommend taking last known flag for each child based on finyear due to file being composite of different snapshots in time.

ALPHASTRING X(20)
disability_impairment_nature Person: Disability Impairment, label X(100)

Type of disability impairment/type, as represented by a concatenation of labels (indicating multiple selections).


Specific Information:

Record of each disability type recorded against person record
Known data quality issues: Data Appears in single string, with disability types separated by the ; character. Take latest known (by finyear) disability details as snapshots are stationary and a child may have details in 2015 that are superseded by their details in 2019.

ALPHANUMERICSTRING X(100)
cntrowid Person: KiDS Number, Identifier X(14)

A person's internal Department of Communities and Justice (DCJ) Person Identifier from the legacy KiDS system.

CHARACTERSTRING X(14)
contact_id Person: ChildStory Identifier, A-N(8)

Internal Department of Communities and Justice (DCJ) Person identifier from ChildStory. 

CHARACTERSTRING A-N(8)
contact_start_date_date You don't have permission to see this Data Element. -
Specific Information:

Date that contact was created at helpline

- -
contactor_role Service Event: Contactor Role, Label X(50)

The role of the person contacting Helpline within their organisation, or their relationship to the child being reported, as represented by a label.

CHARACTERSTRING X(50)
contactor_type Service Event: Contactor Type, Label X(50)

The type of contact entity (person/organisation) that is contacting the Helpline, as represented by a label.

CHARACTERSTRING X(50)
ContactorTypeGroup Service Event: Contactor Type, Grouped Label X(45)

Type of organisation the person is contacting Helpline from, as represented by a grouped label.

CHARACTERSTRING X(45)
mandatory_reporter Service Event: Mandatory Reporter, Yes/No Label X(3)

Flag indicating whether the contactor type is mapped as a mandatory reporter.


Specific Information:

This is based on mapping contactor type, the individual themselves may not identify as a mandatory reporter.

ALPHASTRING A(3)
mrg_completed Service Event: Mandatory Reporter Guide Completed, Yes/No/Not Asked Label A(10)

A flag indicating whether the contactor completed the Mandatory Reporter Guide before making the report.


Specific Information:

Contactor is asked whether they have completed the Mandatory Reporter Guide before making the report.

CHARACTERSTRING A(10)
primary_contact_reason Service Event: Primary Contact Reason, Label X(40)

Main reason for contacting the Helpline, as represented by a label

ALPHANUMERICSTRING N(40)
helpline_assessment_id Record: Helpline Assessment ID, XXX-NNNNNNN

Unique ID assigned to last Helpline assessment record associated with the contact

CHARACTERSTRING XXX-N(7)
helpline_assessment_start_date Service Event: Start Date, DateTime YYYY-MM-DD

The date a service event commenced

DATETIME YYYY-MM-DD(T00:00:00)
ha_carer_issues_flag Assessment: Carer Issues Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any carer related issues by an Assessment (Helpline/Field), as represented by a code (Y/N).

ALPHASTRING A(A)
ha_cyp_issues_flag You don't have permission to see this Data Element. - - -
ha_domestic_violence_flag You don't have permission to see this Data Element. -
Specific Information:

Flag based on presence of any DV issue in Child Protection Report: Primary Helpline Assessed Issue (Grouped)

- -
ha_emotional_abuse_flag Assessment: Emotional Abuse Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any emotional abuse issues by an Assessment (Helpline/Field), as represented by a yes/no code.

ALPHASTRING A(A)
ha_neglect_flag Assessment: Neglect Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any neglect issues by an Assessment (Helpline/Field), as represented by a yes/no code.

ALPHASTRING A(A)
ha_physical_abuse_flag Assessment: Physical Abuse Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any physical abuse issues by an Assessment (Helpline/Field), as represented by a yes/no code.

ALPHASTRING A(A)
ha_sexual_abuse_flag Assessment: Sexual Abuse Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any sexual abuse issues by an Assessment (Helpline/Field), as represented by a yes/no code.

ALPHASTRING A(A)
ha_other_issues_flag Assessment: Other Issues Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any other issues not covered by other groupings by an Assessment (Helpline/Field), as represented by a yes/no code.

ALPHASTRING A(A)
transferto_district Service Event: NSW Department of Communities and Justice District, Label X(40)

The District of the business unit where the report was sent by Helpline, as represented by a label.


Specific Information:

First district the contact was transferred to from the Helpline

CHARACTERSTRING X(40)
transferto_business_unit Service Event: Business Unit, Label X(50)

The Business Unit where the report was last sent by Helpline or another Business Unit if transferred on.


Specific Information:

First business unit the contact was transferred to from the Helpline

CHARACTERSTRING X(50)
triage_id_last Record: Triage Identifier, X(18)

Unique ID assigned to a Triage record associated with the contact/report

CHARACTERSTRING X(18)
business_unit_triage Service Event: Business Unit, Label X(50)

The Business Unit where the report was last sent by Helpline or another Business Unit if transferred on.

CHARACTERSTRING X(50)
internal_organisation_district Organisation: NSW Department of Communities and Justice District, Label A(25)

A label that represents the area where the NSW Department of Communities and Justice (DCJ) are responsible for the delivery of DCJ services across Community Services and Housing of an organisation that provides services and/or care.


Specific Information:

District in which the business unit that created the triage record is assigned to

ALPHASTRING A(25)
triage_decision_status Service Event: Triage Decision Status, Label X(30)

Indicates the point in the triage process a report is sitting, represented by a label.

ALPHANUMERICSTRING X(30)
allocation_purpose Service Event: Allocation Purpose, Label A(25)

Indicates the purpose of allocating a report to a caseworker, as represented by a label

ALPHASTRING A(25)
legacy_identifier Record: Legacy Triage Identifier, Identifier X(12)

Unique ID associated with triage records migrated from KiDS

ALPHANUMERICSTRING X(12)
closure_reason Service Event: Case Closure Reason, Label X(50)

The reason a case was closed, as represented by a label


Specific Information:

Detailed reason for closing at triage stage

ALPHANUMERICSTRING X(50)
date_closure_decision You don't have permission to see this Data Element. - - -
field_assessment_id_first Record: Field Assessment, Identifier X(19)

Unique Identifier assigned to Field Assessment record by ChildStory


Specific Information:

Unique ID assigned to Field Assessment record by ChildStory (first record)

CHARACTERSTRING X(18)
field_assessment_id_last Record: Field Assessment, Identifier X(19)

Unique Identifier assigned to Field Assessment record by ChildStory


Specific Information:

Unique ID assigned to Field Assessment record by ChildStory (last record)

CHARACTERSTRING X(18)
field_assessment_pathway Service Event: Field Assessment Pathway, Label X(50)

Type of field assessment process undertaken -  the structured decision making safety and risk assessment (SARA) or the Alternate Assessment (AA).  The alternate assessment is used for children in OOHC, or where the reported concerns do not relate to a person within the household.

CHARACTERSTRING X(50)
reasonfor_assessmentnot_proceeding Service Event: Reason for Assessment not Proceeding, Label X(50)

Detailed reason why field assessment did not proceed, as represented by a label

CHARACTERSTRING X(50)
field_assessment_start_date_date Service Event: Start Date, DateTime YYYY-MM-DD

The date a service event commenced

DATETIME YYYY-MM-DD(T00:00:00)
fa_carer_issues_flag Assessment: Carer Issues Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any carer related issues by an Assessment (Helpline/Field), as represented by a code (Y/N).

ALPHASTRING A(A)
fa_cyp_issues_flag You don't have permission to see this Data Element. - - -
fa_domestic_violence_flag Assessment: Domestic Violence Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any Domestic Violence issues by an Assessment (Helpline/Field), as represented by yes/no code.


Specific Information:

Flag based on presence of any DV issue in Child Protection Report: Primary Field Assessed Issue (Grouped)

ALPHASTRING A(A)
fa_emotional_abuse_flag Assessment: Emotional Abuse Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any emotional abuse issues by an Assessment (Helpline/Field), as represented by a yes/no code.

ALPHASTRING A(A)
fa_neglect_flag Assessment: Neglect Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any neglect issues by an Assessment (Helpline/Field), as represented by a yes/no code.

ALPHASTRING A(A)
fa_other_issues_flag Assessment: Other Issues Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any other issues not covered by other groupings by an Assessment (Helpline/Field), as represented by a yes/no code.

ALPHASTRING A(A)
fa_physical_abuse_flag Assessment: Physical Abuse Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any physical abuse issues by an Assessment (Helpline/Field), as represented by a yes/no code.

ALPHASTRING A(A)
fa_sexual_abuse_flag Assessment: Sexual Abuse Flag, Yes/No/NA Code A(A)

Flag to indicate the presence of any sexual abuse issues by an Assessment (Helpline/Field), as represented by a yes/no code.

ALPHASTRING A(A)
alternative_assessment_id Record: Alternative Assessment ID, X(19)

Unique ID assigned to the Alternate Assessment record by ChildStory (first record)

CHARACTERSTRING X(18)
alternate_assessment_start_date Service Event: Start Date, DateTime YYYY-MM-DD

The date a service event commenced

DATETIME YYYY-MM-DD(T00:00:00)
alternate_assessment_risk_level You don't have permission to see this Data Element. - - -
risk_assessment_id_first Record: Risk Assessment ID, X(19)

Unique ID assigned to Risk Assessment record by ChildStory


Specific Information:

Unique ID assigned to Risk Assessment record by ChildStory (first record)

CHARACTERSTRING X(18)
risk_assessment_id_last Record: Risk Assessment ID, X(19)

Unique ID assigned to Risk Assessment record by ChildStory


Specific Information:

Unique ID assigned to Risk Assessment record by ChildStory (last record)

CHARACTERSTRING X(18)
RA_FinalRiskLevel You don't have permission to see this Data Element. - - -
risk_assessment_start_date Service Event: Start Date, DateTime YYYY-MM-DD

The date a service event commenced


Specific Information:

Date risk assessment was started - first

DATETIME YYYY-MM-DD(T00:00:00)
risk_reassessment_first_start_date Service Event: Start Date, DateTime YYYY-MM-DD

The date a service event commenced


Specific Information:

Date risk re-assessment was started - first

DATETIME YYYY-MM-DD(T00:00:00)
rra_first_final_risk_level You don't have permission to see this Data Element. - - -
safety_assessment_id_first Record: Safety Assessment, Identifier X(18)

Unique ID assigned to Safety Assessment record by ChildStory (first record)

CHARACTERSTRING X(18)
safety_assessment_start_date Service Event: Start Date, DateTime YYYY-MM-DD

The date a service event commenced

DATETIME YYYY-MM-DD(T00:00:00)
case_record_id Record: Identifier, X(10)

A sequence of characters represented as an alphanumeric string which uniquely identifies an entity of an account of something, preserved in a lasting form.


Specific Information:

Unique ID assigned to CYPs case by ChildStory

CHARACTERSTRING X(14)
other_helpline_assessed_issues Assessment: Other Assessed Issues, Label X(200)

Multiple other/non-primary assessed issues, as represented by a concatenation of labels (indicating multiple selections).


Specific Information:

Non primary issues recorded by the helpline

CHARACTERSTRING X(200)
other_field_assessment_assessed_issues You don't have permission to see this Data Element. - - -
ageat_contact Person: Age, Total Years NNN

The age of the person in (completed) years at a specific point in time.


Specific Information:

Age of CYP at the time the contact was made to the helpline

NUMBERSTRING NNN
case_plan_status Person: Case Status, Label X(30)

Approval/closure status of a case, as represented by a label


Specific Information:

Approval/closure status of a CYPs case plan record

ALPHANUMERICSTRING X(30)
case_closure_reason Service Event: Case Closure Reason, Label X(50)

The reason a case was closed, as represented by a label


Specific Information:

Known data quality issues: Reason can be entered while the case is still active. Closed or Closed Approved AND a closure date = closed, all else considered Active.

ALPHANUMERICSTRING X(50)
case_end_date_date Service Event: End Date, DateTime YYYY-MM-DD

The date a service event was completed.


Specific Information:

Unique ID assigned to CYPs case by ChildStory
Known data quality issues: Date can be recorded at any time, even when case is active. Closed or Closed Approved AND a closure date = closed, all else considered Active.

DATETIME YYYY-MM-DD(T00:00:00)
reported_by You don't have permission to see this Data Element. -
Specific Information:

The type of contactor that wants to report a concern about a child or young person

- -
first_name Person: Given Name, Text X(50)

The name of a person within the family group or by which the person is socially identified.

ALPHANUMERICSTRING X(50)
last_name Person: Family Name, Text X(50)

The text that represents a name by which a person’s family group may be identified. That part of a name a person usually has in common with some other members of his/her family, as distinguished from his/her given names.

ALPHANUMERICSTRING X(50)
contact_origin Service Event: Contact, Label X(25)

The means by which a Concern Report was received, as represented by a label

ALPHANUMERICSTRING X(25)
residential_address_postcodelocationatcontact Person: Australian Postcode, Code NNNN

The numeric descriptor for an Australian postal delivery area, aligned with locality, suburb or place for the address of a person.


Specific Information:

Known data quality issues: Only available from 2019/20 onwards.
 

NUMBERSTRING NNNN
ChildStoryID_ContactID Person: ChildStory Identifier, A-N(8)

Internal Department of Communities and Justice (DCJ) Person identifier from ChildStory. 

CHARACTERSTRING A-N(8)
DatePartitioned Record: Date, YYYY-MM-DD

Calendar date relating to a record, represented by a sequence of numbers identifying a particular year (YYYY), month (MM), and day (DD)

DATE YYYY-MM-DD
IngestTime Record: DateTime Stamp, YYYY-MM-DD

A sequence of characters or encoded information identifying when a certain event occurred, on what day, and optionally including what particular time of day.

DATETIME YYYY-MM-DD(T00:00:00)
BatchIngestTime Record: DateTime Stamp, YYYY-MM-DD

A sequence of characters or encoded information identifying when a certain event occurred, on what day, and optionally including what particular time of day.

DATETIME YYYY-MM-DD(T00:00:00)
IngestType Record: Ingest Type, Label A(6)

File (data) ingestion process type, represented by a label.

ALPHASTRING A(6)
filename Record: Filename, Text X(200)

File name (data) ingested into BigQuery, represented by text.

ALPHANUMERICSTRING X(200)