Schema Info

Schema Name: sfdl_prod_mssql.sitelink_csl1paymenttypes

created: 2018-11-12 10:57:02
disabled: False
format: raw
id: 572
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_mssql",
    "table": "sitelink_csl1paymenttypes"
}

type: mssql

Schema Versions: 15

Version 1717420

created: 2026-04-17 00:04:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-17/1776402286'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-17/1776402286
id: 1717420
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 162163534
updated: 2026-04-17 00:05:07

Version 1716179

created: 2026-04-16 00:05:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-16/1776315895'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-16/1776315895
id: 1716179
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 162107716
updated: 2026-04-16 00:05:18

Version 1714988

created: 2026-04-15 00:03:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-15/1776229434'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-15/1776229434
id: 1714988
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 162051875
updated: 2026-04-15 00:04:10

Version 1713783

created: 2026-04-14 00:04:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-14/1776143083'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-14/1776143083
id: 1713783
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161996280
updated: 2026-04-14 00:05:05

Version 1712561

created: 2026-04-13 00:04:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-13/1776056671'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-13/1776056671
id: 1712561
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161938371
updated: 2026-04-13 00:04:50

Version 1711353

created: 2026-04-12 00:04:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-12/1775970235'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-12/1775970235
id: 1711353
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161888947
updated: 2026-04-12 00:04:15

Version 1710165

created: 2026-04-11 00:04:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-11/1775883873'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-11/1775883873
id: 1710165
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161837221
updated: 2026-04-11 00:04:53

Version 1709015

created: 2026-04-10 00:04:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-10/1775797469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-10/1775797469
id: 1709015
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161781596
updated: 2026-04-10 00:04:59

Version 1707869

created: 2026-04-09 00:04:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-09/1775711072'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-09/1775711072
id: 1707869
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161726525
updated: 2026-04-09 00:04:51

Version 1706658

created: 2026-04-08 00:04:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-08/1775624658'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-08/1775624658
id: 1706658
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161671086
updated: 2026-04-08 00:04:35

Version 1705480

created: 2026-04-07 00:03:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-07/1775538222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-07/1775538222
id: 1705480
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161615151
updated: 2026-04-07 00:03:59

Version 1704245

created: 2026-04-06 00:04:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-06/1775451860'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-06/1775451860
id: 1704245
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161557146
updated: 2026-04-06 00:04:50

Version 1703059

created: 2026-04-05 00:04:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-05/1775365468'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-05/1775365468
id: 1703059
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161510874
updated: 2026-04-05 00:04:48

Version 1701881

created: 2026-04-04 00:04:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-04/1775279074'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-04/1775279074
id: 1701881
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161455691
updated: 2026-04-04 00:04:59

Version 1700677

created: 2026-04-03 00:05:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-03/1775192694'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-03/1775192694
id: 1700677
processed: 1

raw_data:

{
    "OldPK": 16,
    "PmtTypeID": 0,
    "PmtType_TermID": 4,
    "SiteID": 1,
    "bAllowOnLinePmts": 9,
    "bAllowRefunds": 10,
    "bAllowReversal": 8,
    "bDisabled": 11,
    "bPermanent": 12,
    "dDeleted": 13,
    "dUpdated": 14,
    "iPmtGroup": 3,
    "sCategory": 7,
    "sDefAcctCode": 2,
    "sDefPmtTypeDesc": 5,
    "sPmtTypeDesc": 6,
    "uTS": 15
}

schema_attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

schema_name_id: 572
schema_scan_id: 161396941
updated: 2026-04-03 00:05:11

Schema Scans: 15

Last at 2026-04-17 00:04:53

Scan 162163534

duration: 0:00:14.550498

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162163534

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-17/1776402286",
        "key": "raw/Csl1PaymentTypes/2026-04-17/1776402286/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3428531501545994452,
        "service_name": "Default Service",
        "span_id": 6670856694774608439,
        "trace_id": 3428531501545994452
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-17 00:04:53
success: True
trace_id: 3428531501545994452

Scan 162107716

duration: 0:00:14.557671

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162107716

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-16/1776315895",
        "key": "raw/Csl1PaymentTypes/2026-04-16/1776315895/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16962738232668871209,
        "service_name": "Default Service",
        "span_id": 949266694653913697,
        "trace_id": 16962738232668871209
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-16 00:05:04
success: True
trace_id: 16962738232668871209

Scan 162051875

duration: 0:00:11.966713

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162051875

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-15/1776229434",
        "key": "raw/Csl1PaymentTypes/2026-04-15/1776229434/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 11137464886169416550,
        "service_name": "Default Service",
        "span_id": 3659581447497768660,
        "trace_id": 11137464886169416550
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-15 00:03:58
success: True
trace_id: 11137464886169416550

Scan 161996280

duration: 0:00:11.993116

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161996280

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-14/1776143083",
        "key": "raw/Csl1PaymentTypes/2026-04-14/1776143083/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 17566449783775870870,
        "service_name": "Default Service",
        "span_id": 7429331311877932067,
        "trace_id": 17566449783775870870
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-14 00:04:53
success: True
trace_id: 17566449783775870870

Scan 161938371

duration: 0:00:14.452495

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161938371

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-13/1776056671",
        "key": "raw/Csl1PaymentTypes/2026-04-13/1776056671/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 18165703159437922263,
        "service_name": "Default Service",
        "span_id": 6639976260787147638,
        "trace_id": 18165703159437922263
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-13 00:04:36
success: True
trace_id: 18165703159437922263

Scan 161888947

duration: 0:00:14.513317

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161888947

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-12/1775970235",
        "key": "raw/Csl1PaymentTypes/2026-04-12/1775970235/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 10614747215018269679,
        "service_name": "Default Service",
        "span_id": 17736671290669492979,
        "trace_id": 10614747215018269679
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-12 00:04:00
success: True
trace_id: 10614747215018269679

Scan 161837221

duration: 0:00:14.443390

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161837221

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-11/1775883873",
        "key": "raw/Csl1PaymentTypes/2026-04-11/1775883873/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16694367446371684577,
        "service_name": "Default Service",
        "span_id": 10984518569065267039,
        "trace_id": 16694367446371684577
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-11 00:04:39
success: True
trace_id: 16694367446371684577

Scan 161781596

duration: 0:00:11.975518

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161781596

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-10/1775797469",
        "key": "raw/Csl1PaymentTypes/2026-04-10/1775797469/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 11025366932928899750,
        "service_name": "Default Service",
        "span_id": 12437611566379184482,
        "trace_id": 11025366932928899750
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-10 00:04:47
success: True
trace_id: 11025366932928899750

Scan 161726525

duration: 0:00:14.400163

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161726525

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-09/1775711072",
        "key": "raw/Csl1PaymentTypes/2026-04-09/1775711072/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 8396893936922176559,
        "service_name": "Default Service",
        "span_id": 9774629769984351394,
        "trace_id": 8396893936922176559
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-09 00:04:37
success: True
trace_id: 8396893936922176559

Scan 161671086

duration: 0:00:12.005893

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161671086

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-08/1775624658",
        "key": "raw/Csl1PaymentTypes/2026-04-08/1775624658/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3625794381674079794,
        "service_name": "Default Service",
        "span_id": 126215474126676033,
        "trace_id": 3625794381674079794
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-08 00:04:23
success: True
trace_id: 3625794381674079794

Scan 161615151

duration: 0:00:11.921785

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161615151

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-07/1775538222",
        "key": "raw/Csl1PaymentTypes/2026-04-07/1775538222/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3415440683274425042,
        "service_name": "Default Service",
        "span_id": 14461744671917578383,
        "trace_id": 3415440683274425042
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-07 00:03:47
success: True
trace_id: 3415440683274425042

Scan 161557146

duration: 0:00:14.460895

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161557146

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-06/1775451860",
        "key": "raw/Csl1PaymentTypes/2026-04-06/1775451860/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 9352954749186913161,
        "service_name": "Default Service",
        "span_id": 15378943806859381184,
        "trace_id": 9352954749186913161
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-06 00:04:36
success: True
trace_id: 9352954749186913161

Scan 161510874

duration: 0:00:14.509036

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161510874

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-05/1775365468",
        "key": "raw/Csl1PaymentTypes/2026-04-05/1775365468/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 13441514709927931096,
        "service_name": "Default Service",
        "span_id": 1188050933997576720,
        "trace_id": 13441514709927931096
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-05 00:04:33
success: True
trace_id: 13441514709927931096

Scan 161455691

duration: 0:00:14.440000

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161455691

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-04/1775279074",
        "key": "raw/Csl1PaymentTypes/2026-04-04/1775279074/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 14568142028763339312,
        "service_name": "Default Service",
        "span_id": 6689806735300765625,
        "trace_id": 14568142028763339312
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-04 00:04:44
success: True
trace_id: 14568142028763339312

Scan 161396941

duration: 0:00:12.127577

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161396941

payload:

{
    "datatype_dict": {
        "OldPK": "int",
        "PmtTypeID": "int",
        "PmtType_TermID": "int",
        "SiteID": "int",
        "bAllowOnLinePmts": "boolean",
        "bAllowRefunds": "boolean",
        "bAllowReversal": "boolean",
        "bDisabled": "boolean",
        "bPermanent": "boolean",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iPmtGroup": "int",
        "sCategory": "string",
        "sDefAcctCode": "int",
        "sDefPmtTypeDesc": "string",
        "sPmtTypeDesc": "string",
        "uTS": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-03/1775192694",
        "key": "raw/Csl1PaymentTypes/2026-04-03/1775192694/Csl1PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_Csl1PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 14006961538946142193,
        "service_name": "Default Service",
        "span_id": 10444960670939927231,
        "trace_id": 14006961538946142193
    }
}

running: False
schema_name_id: 572
start_time: 2026-04-03 00:04:59
success: True
trace_id: 14006961538946142193

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "OldPK": "int",
    "PmtTypeID": "int",
    "PmtType_TermID": "int",
    "SiteID": "int",
    "bAllowOnLinePmts": "boolean",
    "bAllowRefunds": "boolean",
    "bAllowReversal": "boolean",
    "bDisabled": "boolean",
    "bPermanent": "boolean",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iPmtGroup": "int",
    "sCategory": "string",
    "sDefAcctCode": "int",
    "sDefPmtTypeDesc": "string",
    "sPmtTypeDesc": "string",
    "uTS": "timestamp"
}

created: 2026-04-17 00:04:54

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-17/1776402286'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-11-12 10:57:02",
        "disabled": false,
        "format": "raw",
        "id": 572,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_mssql",
            "table": "sitelink_csl1paymenttypes"
        },
        "type": "mssql"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "OldPK": "int",
            "PmtTypeID": "int",
            "PmtType_TermID": "int",
            "SiteID": "int",
            "bAllowOnLinePmts": "boolean",
            "bAllowRefunds": "boolean",
            "bAllowReversal": "boolean",
            "bDisabled": "boolean",
            "bPermanent": "boolean",
            "dDeleted": "timestamp",
            "dUpdated": "timestamp",
            "iPmtGroup": "int",
            "sCategory": "string",
            "sDefAcctCode": "int",
            "sDefPmtTypeDesc": "string",
            "sPmtTypeDesc": "string",
            "uTS": "timestamp"
        },
        "created": "2026-04-17 00:04:54",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_csl1paymenttypes`\n(\n `PmtTypeID`  int , `SiteID`  int , `sDefAcctCode`  int , `iPmtGroup`  int , `PmtType_TermID`  int , `sDefPmtTypeDesc`  string , `sPmtTypeDesc`  string , `sCategory`  string , `bAllowReversal`  boolean , `bAllowOnLinePmts`  boolean , `bAllowRefunds`  boolean , `bDisabled`  boolean , `bPermanent`  boolean , `dDeleted`  timestamp , `dUpdated`  timestamp , `uTS`  timestamp , `OldPK`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-mssql-sitelink-prod/raw/Csl1PaymentTypes/2026-04-17/1776402286'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_csl1paymenttypes`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_csl1paymenttypes"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}