|
|
SIRDSTRDTL FILE
UPDATED BY
RD88.3 RD88.4 RD89.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
STD-STRUCTURE Alpha 10 (Lower Case) RD88.3 RD88.4
Element: Structure RD89.1
STD-LEVEL Alpha 20 RD88.3 RD88.4
Element: Level RD89.1
STD-LEVEL-PARENT Alpha 20 RD88.3 RD88.4
Element: Level Parent RD89.1
STD-GROUP Alpha 20 (Lower Case) RD88.3 RD88.4
Element: Group
STD-ID Alpha 20 (Lower Case) RD88.3 RD88.4
Element: Id RD89.1
STD-SEQ-NBR Numeric 6 RD88.3 RD88.4
Element: Seq Nbr
STD-SUB-STRUCTURE Alpha 10 (Lower Case) RD88.3 RD88.4
Element: Sub Structure
STD-DESCRIPTION Alpha 50 (Lower Case) RD88.3 RD88.4
Element: Description This field contains the description. RD89.1
STD-ASSISTANT Alpha 1 RD88.3 RD88.4
Element: Assistant N = No
Y = Yes
STD-DIRECTION Alpha 1 RD88.3 RD88.4
Element: Direction This field will let the system know if
the API is being used for Inbound
purposes or Outbound Purposes.
L = Left
R = Right
T = Top
B = Bottom
C = Center
STD-DATE Numeric 8 (yyyymmdd) RD88.3 RD88.4
Element: Date This field contains the system date
when this was created.
STD-TIME Numeric 6 (hhmmss) RD88.3 RD88.4
Element: Time
STD-STRUCT-DESC Derived
Element: Struct Desc
STD-CHILD-EXISTS Derived
Element: Child Exists
STD-SUB-STRUCT Derived
Element: Sub Struct
STD-ID-RECORD Derived
Element: Id Record
SIRDSTRDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
STDSET1 STRUCTURE RD88.3 RD88.4
LEVEL RD88.5 RD89.1
STDSET2 GROUP KeyChange
STRUCTURE
LEVEL
LEVEL-PARENT
STDSET3 STRUCTURE KeyChange RD88.3 RD88.4
LEVEL-PARENT RD89.1
LEVEL
STDSET4 ID KeyChange
STRUCTURE
LEVEL
LEVEL-PARENT
STDSET5 STRUCTURE KeyChange RD88.5
LEVEL-PARENT
SEQ-NBR
LEVEL
SIRDSTRDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Email LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"EMAIL " -> LMV-MATRIX-CAT
Job Title LOMXVALUE Not Required
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"JOB-TITLE " -> LMV-MATRIX-CAT
Name First LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-FIRST " -> LMV-MATRIX-CAT
Name Last LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-LAST " -> LMV-MATRIX-CAT
Parent SIRDSTRDTL Not Required
Valid When STD-LEVEL-PARENT != Spaces
STD-STRUCTURE -> STD-STRUCTURE
STD-LEVEL-PARENT -> STD-LEVEL
Picture LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"PICTURE " -> LMV-MATRIX-CAT
Sirdgrp SIRDGRP Required
STD-GROUP -> RDG-GROUP
Sirdgrpstt SIRDGRPSTT Required
STD-STRUCTURE -> RST-STRUCTURE
STD-GROUP -> RST-GROUP
Sirdidhdr SIRDIDHDR Required
STD-ID -> IDH-ID
Sirdidstt SIRDIDSTT Required
STD-STRUCTURE -> IDS-STRUCTURE
STD-ID -> IDS-ID
Sirdstruct SIRDSTRUCT Required
STD-STRUCTURE -> STR-STRUCTURE
SIRDSTRDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Child Exists SIRDSTRDTL
STD-STRUCTURE -> STD-STRUCTURE
STD-LEVEL -> STD-LEVEL-PARENT
STD-LEVEL
Sirdgrprol SIRDGRPROL
STD-GROUP -> RGP-GROUP
RGP-ROLE
|
