TRANS EMP NO decimal(8.0) 0019 - 0026 SUPPLIER FILE REF char(16) 0027 - 0042 FILE VERSION NO decimal(3.0) 0043 - 0045 Ten (010) CARRIAGE RETURN char(1) 0046 - 0046 Constant LINE FEED char(1) 0047 - 0047 Constant record - Type 1 - Worker and all claim details record length of 1412 characters including CR/LF record delimiter: Position Values EDI DOC TYP TCDE char(3) 0001 - 0003 7.2 Table 2 EDI REC TYPE IND char(1) 0004 - 0004 7.6 6 SI CLAIM NO char(20) 0005 - 0024 EMP NO decimal(8.0) 0025 - 0032 EMP LOCN NO decimal(4.0) 0033 - 0036 Worker details BIRTH DTE decimal(8.0) 0037 - 0044 DECEASED DTE decimal(8.0) 0045 - 0052 LANGUAGE TCDE char(4) 0053 - 0056 Appendix C GENDER IND char(1) 0057 - 0057 7.4 4 WORKER GIVEN NME char(25) 0058 - 0082 WORKER MIDDLE NME Char (25) 0083 - 0107 WORKER SUR NME char(25) 0108 - 0132 WORKER PRIOR SUR NME 1 char(25) 0133 - 0157 WORKER SUR NME 2 char(25) 0158 - 0182 WORKER PRIOR SUR NME 3 char(25) 0183 - 0207 WORKER POSTCODE decimal(4.0) 0208 - 0211 INJ DTE decimal(8.0) 0212 - 0219
BS DIGESTIVE PARTS char(50) 0782 - 0831 BS EAR NOSE THROAT FLG char(1) 0832 - 0832 BS EAR NOSE THROAT PERC decimal(3.0) 0833 - 0835 BS EAR NOSE THROAT PARTS char(50) 0836 - 0885 BS ENDOCRINE FLG char(1) 0886 - 0886 BS ENDOCRINE PERC decimal(3.0) 0887 - 0889 BS ENDOCRINE PARTS char(50) 0890 - 0939 BS HEMAT BLOOD FLG char(1) 0940 - 0940 BS HEMAT BLOOD PERC decimal(3.0) 0941 - 0943 BS BLOOD PARTS char(50) 0944 - 0993 BS LOWER EXTREMITY FLG char(1) 0994 - 0994 BS LOWER EXTREMITY PERC decimal(3.0) 0995 - 0997 BS LOWER EXTREMITY PARTS char(50) 0998 - 1047 L,R,B BS NERVOUS SYS FLG char(1) 1048 - 1048 BS NERVOUS SYS PERC decimal(3.0) 1049 - 1051 BS NERVOUS SYS PARTS char(50) 1052 - 1101 BS NIHL FLG char(1) 1102 - 1102 BS NIHL PERC decimal(3.0) 1103 - 1105 BS PSYCH INJ PMH FLG char(1) 1106 - 1106 BS PSYCH INJ PMH PERC decimal(3.0) 1107 - 1109 BS RESPIRATORY FLG char(1) 1110 - 1110 BS RESPIRATORY PERC decimal(3.0) 1111 - 1113 BS SKIN FLG char(1) 1114 - 1114 BS SKIN PERC decimal(3.0) 1115 - 1117 BS SKIN TEMSKI FLG char(1) 1118 - 1118 BS SKIN TEMSKI PERC decimal(3.0) 1119 - 1121 BS SPINE FLG char(1) 1122 - 1122 BS SPINE PERC decimal(3.0) 1123 - 1125
APPRENTICE FLG Char (1) Optional Indicates if the injured worker is an apprentice/trainee. Must be Y = Yes or N = No. BIRTH DTE Decimal (8.0) Mandatory Birth date of worker. Must be numeric. Must be in date format of YYYYMMDD. On existing claims, must equal current value of BIRTH DTE. If an update to a date of birth is required, this will need to be a manual change performed by RTWSA prior to submitting your updated record. Please contact to amend. BODILY LOCATION CODE Decimal (3.0) Mandatory (i.e. non-zero) if the is being reported updated and RTWSA does not have a value recorded. The bodily location of injury/disease classification per section E of TOOCS 3.1. This is intended to identify the part of the body affected by the most serious injury or disease. Supply zeros by default until claim update is reported. BODY SYSTEMS (BS) ASSESSED FOR WHOLE PERSON IMPAIRMENT (s58, s56) When a payment is made for non-economic loss (s58) and economic loss (s56), the TOTAL WPI PERCENTAGE must be supplied and whole person impairment assessment results supplied for all the body systems assessed. For each of the 16 body systems the claim record has a flag, a percentage, and where there are body parts within the system a text field for body part & side information (such as “left wrist tendonitis”). Definitions for the Body Systems are contained with the “Return To Work Scheme – Impairment Assessment Guidelines”. For example BS UPPER EXTREMITY FLG Char(1) Optional.
LANGUAGE TCDE values LANGUAGE Description TCDE 1102 Gaelic (Irish) 1103 Gaelic (Scottish) 1104 Welsh 1201 English 1300 German 1302 Yiddish 1401 1501 Danish 1503 Norwegian 1504 Swedish 2101 French 2201 Greek 2302 Portuguese 2303 Spanish 2401 Italian 2501 Maltese 3101 Latvian 3102 Lithuanian 3201 Estonian 3202 Finnish 3301 Hungarian 3402 Russian 3403 Ukrainian 3500 Slavic (Yugoslavian) 3502 Bulgarian 3503 Croatian 3504 Macedonian 3505 Serbian 3506 Slovene 3601 Czech 3602 Polish 3603 Slovak 3901 Albanian 3902 Armenian LANGUAGE Description TCDE 3904 Romanian 3999 Eastern European (Including Romany) 4101 Persian (Farsi) 4202 Arabic 4301 Turkish 5103 5201 Bengali 5203 Hindi 5209 Sinhalese 5210 Urdu 6000 South East Asian 6101 Burmese 6301 6302 Vietnamese 6401 Lao 6402 Thai 6501 Bahsa Indonesia 6504 Filipino Languages 6507 Tagaloq 6508 Tetum 7100 Chinese 7101 Cantonese 7104 Mandarin 7201 Japanese 7301 Korean 8000 Oceanic Languages 8100 Australian Aboriginal 8301 Fijian 8303 Maori (Cook Island) 8304 Maori (New Zealand) 8309 Tongan 9200 African Languages 9201 Afrikaans 9501 Sign Language (AUSLAN)
SERIOUS INJURY FLG (ECU and ECC) SERIOUS INJURY ASSESSMENT DTE (ECU and ECC) NIIS FLG (ECU and ECC) Renamed attributes: DIA ADVISORY DTE to SWSA ADVISORY DTE (ERF) SEX IND to GENDER IND (ERF) PAY PERIOD STRT DTE to FILLER (ECU and ECC) PAY PERIOD END DTE to FILLER (ECU and ECC) changes Batch and file concepts - update platform and browser combinations Attribute Definitions New attributes: COMMON LAW COMMENCED FLG SERIOUS INJURY FLG SERIOUS INJURY ASSESSMENT DTE NIIS FLG Renamed attributes: DIA ADVISORY DTE to SWSA ADVISORY DTE. SEX IND to GENDER IND ‘OH&S Act’ reference updated for SWSA ADVISORY DTE 4 – TXN CDE values New entries: DOR for ‘Deed of Release’ IMT description changed to ‘Income Support’ RDI description changed to ‘Redemption/Commutation of Income Support’ LEL for ‘Lump Sum – Economic Loss’ LSU description changed to ‘Lump Sum – Non-Economic Loss’ 6 – Payment Type Combinations Common Law (CLA) to be reused - description updated New entry: LEL for ‘Lump Sum – Economic Loss’ IMT description changed to ‘Income Support’ RDI description changed to ‘Redemption/Commutation of Income Support’ LSU, RDI, RDM and TRV descriptions updated with revised section references 12 – Language Tcde Values - Moved to Appendix E Table 13 – Country of Birth Cde Values - Moved to Appendix F Data Flow Diagram - Revised diagram EDI Processing Flowchart - Revised flowchart Transmission Procedures - ‘Ongoing claim payments update – ECU’ section: update number of payment types and categories from 18 to 20. APPENDIX D Common Error Messages - New ‘Batch rejected sequence error’ message added; Rename ‘WC’ references to ‘RTWSA’ (ReturnToWork SA) Terminology – change references from ‘income maintenance’ to ‘income support’ [Note: the code table descriptions in this document may not reflect the actual code table descriptions] 11/8/2004 6.0b PH Initial ‘Draft’ Version created from ‘Tech60b.doc’ which provided complete details for NDS2 requirements. 24/8/2004 6.1 PH Changes to ERF, ECU, CUE and ECC file formats and inclusion of new fields and/or removal of existing fields.