Shared Top Border
NSRSN Logo

North Sound 
Mental Health Administration

NSMHA-CIS Data Dictionary

Shared Left Border
Data Dictionary Home
Code Tables
Data Elements
General Notes
Transactions

 

Cascade Delete

This transaction allows for the mass deletion of records for the given consumer. This will remove all information about a consumer.

Transaction

Transaction IDTransaction DescriptionStatusStatus Date
131.01Cascade DeleteFinal5/1/2005

Transaction Details

KeyField IDField CodeField NameField DescriptionActions AllowedChar Length
 101073CV01RCODETransaction IDNN6
 030010CV02RACTIONAction CodeNN1
 030760CV03RSNIDRSN Report UnitNN3
K030020CV04RORGAgency Reporting Unit IDNN5
 030001CV05RLGUIDUnique IdentifierLA11
K030620CV06PNMaster Client NumberNN11

Validations

Field IDValidationCodeTable
030010001 - Value Cannot Be Null 
030020001 - Value Cannot Be Null 
030620001 - Value Cannot Be Null 
030620002 - Code Invalid 
030620023 - Consumer ID already deleted 
030760001 - Value Cannot Be Null 
101073001 - Value Cannot Be Null 

Transaction Notes

Note_DateNote
 NSMHA is to be notified before submitting this transaction.
 This transaction shall not be submitted as a part of a regular batch process. The Cascade Delete transaction, when submitted, is the only transaction in the batch.
 _rlguid^ is expected to be null.

Shared Bottom Border


Send mail to Michael White with questions or comments about this web site.
North Sound Mental Health Administration