SIRDTRANS FILE
UPDATED BY
RD90.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RDT-TYPE Alpha 2 RD90.1
Element: Type ID = Id
GR = Group
TH = Thing
AT = Attribute
RDT-TYPE-GROUP Alpha 20 (Lower Case) RD90.1
Element: Type Group
RDT-TYPE-ID Alpha 15 (Lower Case) RD90.1
Element: Type Id
RDT-EFFECTIVE-DATE Numeric 8 (yyyymmdd) RD90.1
Element: Effective Date
RDT-EFFECTIVE-TIME Numeric 6 (hhmmss) RD90.1
Element: Effective Time
RDT-SEQ-NBR Numeric 6 RD90.1
Element: Seq Nbr
RDT-APPLY-TO Alpha 25 (Lower Case) RD90.1
Element: Apply To
RDT-BEFORE-VALUE Alpha 55 (Lower Case) RD90.1
Element: Before Value
RDT-AFTER-VALUE Alpha 55 (Lower Case) RD90.1
Element: After Value
RDT-STATUS Numeric 1 RD90.1
Element: Status This field contains the status of the
transaction.
1 = Pending
2 = Updated
3 = Historical
RDT-DATE Numeric 8 (yyyymmdd) RD90.1
Element: Date This field contains the system date
when this was created.
RDT-TIME Numeric 6 (hhmmss) RD90.1
Element: Time
SIRDTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RDTSET1 TYPE RD90.1
TYPE-GROUP
TYPE-ID
EFFECTIVE-DATE
EFFECTIVE-TIME
SEQ-NBR
SIRDTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdgrp SIRDGRP Required
When RDT-TYPE = "GR"
RDT-TYPE-GROUP -> RDG-GROUP
Sirdidhdr SIRDIDHDR Required
When RDT-TYPE = "ID"
RDT-TYPE-ID -> IDH-ID
|
