Document data mappings (JSON Schema -> MSSQL)
| Oracle | SQL | Example | Done |
|---|---|---|---|
| Number(10,0) | BIGINT | SCHOOLENTRYGRADELEVEL | Done |
| Number(1,0) | BIT | ISMIGRATED | Done |
| Number(p,0) | BIGINT | PERSONADDRESS.COUNTRYCODESETID | Done |
| Number(p,s) | Numeric(p,s) | PERSONADDRESS.GEOCODELATITUDE | Done (Numeric(16,10) for this example |
| FLOAT | FLOAT | CUSTOMRANK_GPA | Done - Numeric(19,4) - Can't determine this from Schema. Not important enough to fix |
| VARCHAR2(x) | VARCHAR(X), X>8000 varchar(max) | STATE_STUDENTNUMBER VARCHAR2(32) | Done |
| CLOB | VARCHAR(MAX) | CUSTOM | Done |
| BLOB | VARBINARY(MAX) | ENROLLMENT_TRANSFER_INFO | Done |
| NCLOB | NVARCHAR(MAX) | PSM_ASSETCONTENT.CLOB_CONTENT | Done |
| NVARCHAR2(x) | NVarchar(x) for x>4000 nvarchar(max) | ||
| Date | Date | ALERT_DISCIPLINEEXPIRES | Done |
| TimeStamp | Datetime2(7) | TRANSACTION_DATE | Done |