SIRDNONMEM FILE
UPDATED BY
RD32.5 RD32.6
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CDT-ID Alpha 20 (Lower Case) RD32.5 RD32.6
Element: Id
CDT-NON-MEMBER-ID Alpha 20 (Lower Case) RD32.5 RD32.6
Element: Non Member Id
CDT-DESCRIPTION Alpha 50 (Lower Case) RD32.5 RD32.6
Element: Description This field contains the description.
CDT-COMPANY-NAME Alpha 50 (Lower Case) RD32.5 RD32.6
Element: Company Name
CDT-ADDR-1 Alpha 50 (Lower Case) RD32.5 RD32.6
Element: Addr 1
CDT-ADDR-2 Alpha 50 (Lower Case) RD32.5 RD32.6
Element: Addr 2
CDT-ADDR-3 Alpha 50 (Lower Case) RD32.5 RD32.6
Element: Addr 3
CDT-ADDR-4 Alpha 50 (Lower Case) RD32.5 RD32.6
Element: Addr 4
CDT-ADDR-5 Alpha 50 (Lower Case) RD32.5 RD32.6
Element: Addr 5
CDT-STATE-PROV Alpha 2 RD32.5 RD32.6
Element: State Prov
CDT-POSTAL-CD Alpha 20 (Lower Case) RD32.5 RD32.6
Element: Postal Cd
CDT-COUNTRY-CODE Alpha 2 RD32.5 RD32.6
Element: Country Code
CDT-EMAIL Alpha 100 (Lower Case)
Element: Email
CDT-HOME-PHONE Alpha 20 (Lower Case) RD32.5 RD32.6
Element: Home Phone
CDT-WORK-PHONE Alpha 20 (Lower Case) RD32.5 RD32.6
Element: Work Phone
CDT-WORK-EXT Alpha 10 (Lower Case) RD32.5 RD32.6
Element: Work Ext
CDT-CELL-PHONE Alpha 20 (Lower Case) RD32.5 RD32.6
Element: Cell Phone
CDT-FAX Alpha 20 (Lower Case) RD32.5 RD32.6
Element: Fax
CDT-PAGER Alpha 20 (Lower Case) RD32.5 RD32.6
Element: Pager
CDT-URL Alpha 256 (Lower Case)
Element: Url
CDT-OTHER-INFO Alpha 256 (Lower Case) RD32.5 RD32.6
Element: Other Info
CDT-JOB-TITLE Alpha 50 (Lower Case) RD32.5 RD32.6
Element: Job Title
CDT-JOB-DEPT Alpha 50 (Lower Case) RD32.5 RD32.6
Element: Job Dept
CDT-DATE Numeric 8 (yyyymmdd) RD32.5 RD32.6
Element: Date This field contains the system date
when this was created.
CDT-TIME Numeric 6 (hhmmss) RD32.5 RD32.6
Element: Time
CDT-ID-RECORD Derived
Element: Id Record
SIRDNONMEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDTSET1 ID RD32.2 RD32.4
NON-MEMBER-ID RD32.5 RD32.6
CDTSET2 NON-MEMBER-ID
ID
SIRDNONMEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdctry SIRDCTRY Required
CDT-COUNTRY-CODE -> WCT-COUNTRY-CODE (WCTSET1)
Sirdidhdr SIRDIDHDR Required
CDT-ID -> IDH-ID
Sirdstprov SIRDSTPROV Required
CDT-COUNTRY-CODE -> WSP-COUNTRY-CODE
CDT-STATE-PROV -> WSP-STATE-PROV
SIRDNONMEM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdidcol SIRDIDCOL
CDT-ID -> ICL-ID
CDT-NON-MEMBER-ID -> ICL-NON-MEMBER-ID
ICL-COLLECTION
|
