27CREATE TABLE &LIBREF..ENTITY(
28 REPORTING_DT DATE label =
'Reporting Date' FORMAT = &DTFMT.,
29 ENTITY_ID VARCHAR(32) label =
'Entity Id',
30 ENTITY_ID VARCHAR(32) label =
'Entity Id',
31 ENTITY_NM VARCHAR(120) label =
'Entity Name',
32 ENTITY_DESC VARCHAR(300) label =
'Entity Description',
33 COUNTRY_CD VARCHAR(9) label =
'Country Code',
34 ENTITY_ROLE_CD VARCHAR(15) NOT NULL label =
'Entity Role Code',
35 LEGAL_ENTITY_FLG VARCHAR(3) label =
'Legal Entity Flag',
36 GROUP_ID VARCHAR(32) label =
'Group Id',
37 REPORTING_CURRENCY_CD VARCHAR(9) NOT NULL label =
'Reporting Currency',
38 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, ENTITY_ID)