MEDCARE_AUS_LNG(SQL Table) |
Index Back |
---|---|
AUS - Medicare Item DetailsThis table stores details of Medical items that can be claimed for reimbursement purposes. The codes mirror the Medicare Item codes established by the Australian Federal Government. This is a language record for MEDCARE_ITM_AUS |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | MEDICARE_ITM_AUS | Character(6) | VARCHAR2(6) NOT NULL | Medicare Item ID |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |