Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
cost_date | date | 6 | √ | null |
|
|
||
reporting_month | date | 6 | √ | null |
|
|
||
PPPL_FacID | varchar | 6 | null |
|
|
|||
FacilityCode | varchar | 10 | √ | null |
|
|
||
Posted | datetime | 16,3 | null |
|
|
|||
FacName | varchar | 30 | null |
|
|
|||
RxNo | int | 4 | null |
|
|
|||
FillNo | int | 4 | √ | null |
|
|
||
DispenseDate | date | 6 | null |
|
|
|||
TransType | char | 1 | null |
|
|
|||
DrugLabelName | varchar | 30 | √ | null |
|
|
||
InvoiceGroupCode | varchar | 6 | √ | null |
|
|
||
InvoiceGroup | varchar | 20 | √ | null |
|
|
||
QTY | numeric | 11,4 | √ | null |
|
|
||
AddQtyBilled | numeric | 11,4 | √ | null |
|
|
||
DaysSupply | numeric | 7,2 | √ | null |
|
|
||
Amount | money | 21,4 | √ | null |
|
|
||
PerDiem | varchar | 10 | √ | null |
|
|
||
GPIDrugGroup | varchar | 60 | √ | null |
|
|
||
GPIDrugClass | varchar | 60 | √ | null |
|
|
||
GPISUBDrugClass | varchar | 60 | √ | null |
|
|
||
GPIDrugName | varchar | 60 | √ | null |
|
|
||
FileCreationDate | date | 6 | null |
|
|
|||
MonthEndInvDate | date | 6 | null |
|
|