PatientAdministrationCustom


Description

Extended patient case administration storing comprehensive custom fields and specialized administrative information for patient cases. This table extends the core PatientAdministration functionality with agency-specific custom fields, detailed case management data, clinical information, service coordination details, and specialized documentation requirements for different healthcare programs and compliance needs.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkID int identity 4 √ null

Primary key - Unique identifier for each custom administration record
fkAdmitID int 4 null

Case reference - Links to PatientAdministration table for the associated case/admission
ReferralDate datetime 16,3 √ null

Referral date - Date when patient was referred for services
ReferralSource nvarchar 200 √ null

Referral source - Source of the referral (doctor, agency, school, etc.)
ReferralName nvarchar 500 √ null

Referral contact name - Name of person or organization making the referral
ReferralPhone nvarchar 40 √ null

Referral phone - Phone number of referral source for contact
DevelopmentalConcerns nvarchar 500 √ null

Developmental concerns - Specific developmental concerns noted at referral
Status nvarchar 200 √ null

Case status - Current administrative status of the case
45DayTimeline datetime 16,3 √ null

45-day timeline - Date related to 45-day service timeline requirements
AgeOutDate datetime 16,3 √ null

Age out date - Date when patient will age out of services
OtherProgramsInvolved nvarchar 200 √ null

Other programs - Other programs or services the patient is involved with
ReferralConcerns nvarchar 1073741823 √ null

Referral concerns - Detailed concerns and reasons noted in the referral
PaymentType nvarchar 200 √ null

Payment type - Type of payment arrangement for services
DateCreated datetime 16,3 √ null

Creation date - Timestamp when the custom administration record was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created this administration record
DateUpdated datetime 16,3 √ null

Last update date - Timestamp of the most recent administration record update
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last modified this administration record
DeletedDate datetime 16,3 √ null

Deletion date - Soft delete timestamp for audit trail purposes
Allergies nvarchar 1073741823 √ null

Patient allergies - Known allergies and adverse reactions
BirthLocation nvarchar 1073741823 √ null

Birth location - Location where patient was born
BirthWeight decimal 20 √ null

Birth weight - Patient’s weight at birth
ChildsMedications nvarchar 1073741823 √ null

Current medications - Medications the patient is currently taking
Comments nvarchar 1073741823 √ null

Administrative comments - General administrative comments and notes
CountyOfBirth nvarchar 1073741823 √ null

County of birth - County where patient was born
CPSEMeetingDate datetime 16,3 √ null

CPSE meeting date - Date of Committee on Preschool Special Education meeting
CPSEServiceLocation nvarchar 510 √ null

CPSE service location - Location where CPSE services are provided
CSPEIEPProgram nvarchar 650 √ null

CSPE IEP program - Committee on Special Education IEP program details
CSPELocation nvarchar 510 √ null

CSPE location - Location where CSPE services are provided
CSPENotes nvarchar 1073741823 √ null

CSPE notes - Notes related to Committee on Special Education services
CSPEService nvarchar 510 √ null

CSPE service - Type of Committee on Special Education service
CSPEStartDate datetime 16,3 √ null

CSPE start date - Start date for Committee on Special Education services
DateToTransition datetime 16,3 √ null

Transition date - Date when patient will transition to next level of care
DaysSpentInNICU nvarchar 100 √ null

NICU days - Number of days spent in Neonatal Intensive Care Unit
DescribeTheClient nvarchar 1073741823 √ null

Client description - Detailed description of the patient/client
DifficultOnMostDays nvarchar 1073741823 √ null

Daily challenges - Description of difficulties experienced on most days
EarlyInterventionTransition nvarchar 510 √ null

EI transition - Early intervention transition planning information
Ethnicity nvarchar 200 √ null

Ethnicity - Patient’s ethnic background
GoWellOnMostDays nvarchar 1073741823 √ null

Daily strengths - Description of what goes well on most days
GroupPerWeek decimal 20 √ null

Group sessions per week - Number of group therapy sessions per week
HospitalOfBirth nvarchar 1073741823 √ null

Birth hospital - Hospital where patient was born
HospitalOfDischarge nvarchar 1073741823 √ null

Discharge hospital - Hospital from which patient was discharged
IFSP7 nvarchar 1073741823 √ null

IFSP section 7 - Individualized Family Service Plan section 7 information
IFSPDate datetime 16,3 √ null

IFSP date - Date of Individualized Family Service Plan
IFSPDateofCompletion datetime 16,3 √ null

IFSP completion date - Date when IFSP was completed
IFSPPlanofCare nvarchar 1073741823 √ null

IFSP plan of care - Individualized Family Service Plan care details
IFSPType nvarchar 510 √ null

IFSP type - Type of Individualized Family Service Plan
IndividualPerWeek int 4 √ null

Individual sessions per week - Number of individual therapy sessions per week
LastCheckUp datetime 16,3 √ null

Last checkup date - Date of most recent medical checkup
MedicalDiagnosis nvarchar 1073741823 √ null

Medical diagnosis - Primary medical diagnoses
MedicalHistory nvarchar 1073741823 √ null

Medical history - Comprehensive medical history
Notes nvarchar 1073741823 √ null

Administrative notes - Additional administrative notes and observations
OtherInformation nvarchar 510 √ null

Other information - Additional administrative information
ParentMajorOutcome nvarchar 1073741823 √ null

Parent major outcome - Major outcomes identified by parents
PersonResponsible nvarchar 1073741823 √ null

Person responsible - Person responsible for case management
Provider int 4 √ null

Provider - Healthcare provider assigned to the case
Race nvarchar 500 √ null

Race - Patient’s racial background
RegularCheckUps nvarchar 6 √ null

Regular checkups - Frequency of regular medical checkups
SchoolDistrict nvarchar 200 √ null

School district - School district for educational coordination
WeeksGestation nvarchar 1073741823 √ null

Gestational age - Gestational age at birth in weeks
WhatMakeYourLikeEasier nvarchar 1073741823 √ null

Life improvements - What would make patient’s life easier
PrintNameId int 4 √ null

Print name ID - Identifier for printed name on forms
TestSignature nvarchar 1073741823 √ null

Test signature - Digital signature for testing purposes
FindingsPlanofCare nvarchar 1073741823 √ null

Findings plan of care - Clinical findings and care plan
IFSBInschanged nvarchar 510 √ null

IFSB insurance changed - Indicator if IFSB insurance information changed
FirstDateOfService datetime 16,3 √ null

First service date - Date of first service delivery
notedate datetime 16,3 √ null

Note date - Date when administrative note was created
Priority nvarchar 1073741823 √ null

Priority - Priority level for case management
ClientZipcode nvarchar 510 √ null

Client zip code - Client’s zip code for administrative purposes
TextTime nvarchar 510 √ null

Text time - Time-related text field for administrative use
Classrooms nvarchar 1073741823 √ null

Classrooms - Classroom assignments for the patient
DateValue datetime 16,3 √ null

Date value - Generic date field for administrative use
DateType nvarchar 1073741823 √ null

Date type - Type or category of the date value
CenterLocation varchar 2147483647 √ null

Center location - Location of service center
TestDateField datetime 16,3 √ null

Test date field - Date field for testing purposes
CountOfResidence nvarchar 510 √ null

County of residence - County where patient resides
EvaluationDate datetime 16,3 √ null

Evaluation date - Date of patient evaluation
Somechoice nvarchar 510 √ null

Choice field - Administrative choice or selection field
DateNote datetime 16,3 √ null

Date note - Date when note was created
StartTime nvarchar 50 √ null

Start time - Start time for administrative activity
EndTime nvarchar 50 √ null

End time - End time for administrative activity
CaseType nvarchar 510 √ null

Case type - Type or category of the case
Borough nvarchar 510 √ null

Borough - Borough or administrative region
AcuityDateTaken datetime 16,3 √ null

Acuity assessment date - Date when acuity assessment was taken
AddressofRequestor nvarchar 510 √ null

Requestor address - Address of person requesting services
Comment10 nvarchar 510 √ null

Comment 10 - Additional administrative comment field 10
Comment11 nvarchar 510 √ null

Comment 11 - Additional administrative comment field 11
Comment12 nvarchar 510 √ null

Comment 12 - Additional administrative comment field 12
Comment2 nvarchar 510 √ null

Comment 2 - Additional administrative comment field 2
Comment4 nvarchar 510 √ null

Comment 4 - Additional administrative comment field 4
Comment5 nvarchar 510 √ null

Comment 5 - Additional administrative comment field 5
comment6 nvarchar 510 √ null

Comment 6 - Additional administrative comment field 6
comment7 nvarchar 510 √ null

Comment 7 - Additional administrative comment field 7
Comment8 nvarchar 510 √ null

Comment 8 - Additional administrative comment field 8
Comment9 nvarchar 510 √ null

Comment 9 - Additional administrative comment field 9
Comments3 nvarchar 510 √ null

Comments 3 - Additional administrative comment field 3
CSCNAGEOUT datetime 16,3 √ null

CSCN age out - Children with Special Care Needs age out date
date10 datetime 16,3 √ null

Date 10 - Additional administrative date field 10
Date11 datetime 16,3 √ null

Date 11 - Additional administrative date field 11
Date12 datetime 16,3 √ null

Date 12 - Additional administrative date field 12
date2 datetime 16,3 √ null

Date 2 - Additional administrative date field 2
Date3 datetime 16,3 √ null

Date 3 - Additional administrative date field 3
date4 datetime 16,3 √ null

Date 4 - Additional administrative date field 4
date5 datetime 16,3 √ null

Date 5 - Additional administrative date field 5
date6 datetime 16,3 √ null

Date 6 - Additional administrative date field 6
Date7 datetime 16,3 √ null

Date 7 - Additional administrative date field 7
Date8 datetime 16,3 √ null

Date 8 - Additional administrative date field 8
Date9 datetime 16,3 √ null

Date 9 - Additional administrative date field 9
DateAcuityTaken datetime 16,3 √ null

Date acuity taken - Date when acuity assessment was performed
DateDisclosureRequestSigned datetime 16,3 √ null

Disclosure request signed date - Date when disclosure request was signed
DateMDordersaresent datetime 16,3 √ null

MD orders sent date - Date when medical doctor orders are sent
DateMDordersreceived datetime 16,3 √ null

MD orders received date - Date when medical doctor orders were received
DateMDorderssent datetime 16,3 √ null

MD orders sent date - Date when medical doctor orders were sent
DateofDischarge datetime 16,3 √ null

Discharge date - Date of patient discharge
DateoflastEIPservicesifnoteligible datetime 16,3 √ null

Last EIP services date - Date of last Early Intervention Program services if not eligible
DateofTransition datetime 16,3 √ null

Transition date - Date of transition to next level of care
DateReleased datetime 16,3 √ null

Release date - Date when information was released
DateRequestRecieved datetime 16,3 √ null

Request received date - Date when request was received
DesignatedMD nvarchar 510 √ null

Designated physician - Designated medical doctor for the case
Diagnosis nvarchar 510 √ null

Diagnosis - Medical diagnosis information
DischargeDate datetime 16,3 √ null

Discharge date - Date of patient discharge from services
DoctorsOffice nvarchar 510 √ null

Doctor’s office - Medical doctor’s office information
Familyissues nvarchar 510 √ null

Family issues - Family-related issues and concerns
FirstPotentiallyeligibledateforCPSE datetime 16,3 √ null

First CPSE eligible date - First potentially eligible date for Committee on Preschool Special Education
HighRisk nvarchar 510 √ null

High risk - High risk indicator or assessment
Initials nvarchar 510 √ null

Initials - Staff initials for documentation
IntroduceTransition nvarchar 510 √ null

Introduce transition - Information about introducing transition planning
LastdatetorefertoCPSE datetime 16,3 √ null

Last CPSE referral date - Last date to refer to Committee on Preschool Special Education
MakeUps nvarchar 510 √ null

Make ups - Make-up session information
MDorderssent datetime 16,3 √ null

MD orders sent - Date when medical doctor orders were sent
MutipleService int 4 √ null

Multiple service - Multiple service indicator
NameofRequestor nvarchar 510 √ null

Requestor name - Name of person requesting services
NoteBody nvarchar 1073741823 √ null

Note body - Body text of administrative note
NotePerson nvarchar 510 √ null

Note person - Person associated with the note
NotePriority int 4 √ null

Note priority - Priority level of the note
NoteTitle nvarchar 510 √ null

Note title - Title of the administrative note
NoticetoCPSE datetime 16,3 √ null

Notice to CPSE - Date of notice to Committee on Preschool Special Education
OfficeDoctors nvarchar 510 √ null

Office doctors - Doctors associated with the office
OPActual datetime 16,3 √ null

OP actual - Actual outcome/output date
OPEnd datetime 16,3 √ null

OP end - Outcome/output end date
OPFrequency nvarchar 510 √ null

OP frequency - Outcome/output frequency
OPIFSPDate datetime 16,3 √ null

OP IFSP date - Outcome/output IFSP date
OPMethod nvarchar 510 √ null

OP method - Outcome/output method
OPPast bit 1 √ null

OP past - Past outcome/output indicator
OPProvider nvarchar 510 √ null

OP provider - Outcome/output provider
OPService nvarchar 510 √ null

OP service - Outcome/output service
OPSetting nvarchar 510 √ null

OP setting - Outcome/output setting
OPStart datetime 16,3 √ null

OP start - Outcome/output start date
Persondis nvarchar 510 √ null

Person disclosure - Person for disclosure
PersonSigning nvarchar 510 √ null

Person signing - Person signing the document
PurposeforDisclosure nvarchar 510 √ null

Purpose for disclosure - Purpose for information disclosure
ReasonforDischarge nvarchar 510 √ null

Reason for discharge - Reason for patient discharge
RecordsReleased nvarchar 510 √ null

Records released - Records that were released
Relationship nvarchar 510 √ null

Relationship - Relationship to patient
SC6 nvarchar 510 √ null

SC6 - Service coordination field 6
SCAssigned nvarchar 510 √ null

SC assigned - Service coordinator assigned
SCInitial9 nvarchar 510 √ null

SC initial 9 - Service coordinator initial field 9
SCinitials10 nvarchar 510 √ null

SC initials 10 - Service coordinator initials field 10
SCInitials11 nvarchar 510 √ null

SC initials 11 - Service coordinator initials field 11
SCInitials12 nvarchar 510 √ null

SC initials 12 - Service coordinator initials field 12
SCInitials5 nvarchar 510 √ null

SC initials 5 - Service coordinator initials field 5
SCInitials7 nvarchar 510 √ null

SC initials 7 - Service coordinator initials field 7
SCInitials8 nvarchar 510 √ null

SC initials 8 - Service coordinator initials field 8
ServiceCoordinatorinitials3 nvarchar 510 √ null

Service coordinator initials 3 - Service coordinator initials field 3
servicecoordinatorinitials4 nvarchar 510 √ null

Service coordinator initials 4 - Service coordinator initials field 4
ServiceCoordinatorsInitials nvarchar 510 √ null

Service coordinator initials - Service coordinator initials field
ServiceCoordinatorsInitials2 nvarchar 510 √ null

Service coordinator initials 2 - Service coordinator initials field 2
ServiceStatus nvarchar 510 √ null

Service status - Current status of services
SingleService int 4 √ null

Single service - Single service indicator
SiteofDischarge nvarchar 510 √ null

Site of discharge - Site where patient was discharged
Summary nvarchar 1073741823 √ null

Summary - Administrative summary
TotalAcuity int 4 √ null

Total acuity - Total acuity score
Transition int 4 √ null

Transition - Transition indicator
TransitionConferenceconvenedby nvarchar 510 √ null

Transition conference convened by - Who convened the transition conference
Transitionconverenceconvenednoearlier nvarchar 510 √ null

Transition conference convened no earlier - Transition conference convened no earlier than date
OPProvExp nvarchar 1073741823 √ null

OP provider experience - Outcome/output provider experience

Indexes

Constraint Name Type Sort Column(s)
PK_PatientCustom Primary key Asc pkID
IX_AdmitId Performance Asc fkAdmitID

Relationships

Close relationships within degrees of separation