Service File Views
Updated over a week ago

Service File View: Service File

View name: rpt.service_file

Type: Record

Description: Service File Core Information

Field

Data Type

Notes

service_file_id

integer

service_id

integer

References service_id in rpt.service

case_file_id

integer

References case_file_id in rpt.case_file

case_service_group_id

integer

References case_service_group_id in rpt.case_service_group

Service File View: Service File Profile

View name: rpt.service_file_profile

Type: Profile

Description: Service File Information

Field

Data Type

Notes

service_file_id

integer

References service_file_id in rpt.service_file

service_id

integer

References service_id in rpt.service

case_file_id

integer

References case_file_id in rpt.case_file

case_service_group_id

integer

References case_service_group_id in rpt.case_service_group

service_file_status_id

integer

service_file_status

character varying (20)

service_file_start_date

date

service_file_end_date

date

service_file_estimated_sessions

integer

service_file_text_1

text

service_file_text_2

text

service_file_drop_down_1_id

integer

service_file_drop_down_1

character varying (50)

service_file_drop_down_2_id

integer

service_file_drop_down_2

character varying (50)

service_file_checkbox_1

boolean

service_file_checkbox_2

boolean

service_file_date_1

date

service_file_date_2

date

service_file_memo_1

text

service_file_memo_2

text

service_file_close_reason_id

integer

service_file_close_reason

text

service_file_close_notes

text

Service File View: Service File Note

View name: rpt.service_file_note

Type: Record

Description: Service File Note Information

Field

Data Type

Notes

service_file_note_id

integer

service_file_id

integer

References service_file_id in rpt.service_file

service_file_note_title

text

service_file_note_is_locked

boolean

service_file_note_date

date

worker_id

integer

References worker_id in rpt.worker

service_file_note

text

Service File View: Service File Workers

View name: rpt.service_file_workers

Type: Cross Reference

Description: Service File Workers

Field

Data Type

Notes

service_file_id

integer

References service_file_id in rpt.service_file

worker_id

integer

References worker_id in rpt.worker

service_file_worker_is_primary

boolean

service_file_worker_is_attending

boolean

Service File View: Service File Individuals

View name: rpt.service_file_individuals

Type: Cross Reference

Description: Service File Individuals

Field

Data Type

Notes

service_file_id

integer

References service_file_id in rpt.service_file

individual_id

integer

References individual_id in rpt.individual

service_file_individual_is_presenting

boolean

service_file_individual_drop_down_1_id

integer

asservice_file_individual_drop_down_1

text

service_file_individual_drop_down_2_id

integer

asservice_file_individual_drop_down_2

text

service_file_individual_checkbox_1

boolean

service_file_individual_checkbox_2

boolean

Service File View: Service File Individual Presenting Issues

View name: rpt.service_file_individual_presenting_issues

Type: List

Description: Service File Individual Presenting Issues

Field

Data Type

Notes

service_file_id

integer

References service_file_id in rpt.service_file

individual_id

integer

References individual_id in rpt.individual

presenting_issue_id

integer

References presenting_issue_id in rpt.presenting_issues

Service File View: Service File Bluebooks

View name: rpt.service_file_bluebooks

Type: Cross Reference

Description: Service File Collateral Contacts

Field

Data Type

Notes

service_file_id

integer

References service_file_id in rpt.service_file

bluebook_id

integer

References bluebook_id in rpt.bluebook

Service File View: Service File Documents

View name: rpt.service_file_documents

Type: Cross Reference

Description: Service File Documents

Field

Data Type

Notes

service_file_id

integer

References service_file_id in rpt.service_file

document_id

integer

References document_id in rpt.document

Service File View: Service File Referrals

View name: rpt.service_file_referrals

Type: Cross Reference

Description: Service File Referrals

Field

Data Type

Notes

service_file_id

integer

References service_file_id in rpt.service_file

referral_id

integer

References referral_id in rpt.referral

Did this answer your question?