CEDE 9.0 Database Reference
tOutputTypPerspectiveXref_NGM Table
AIRReference Database : tOutputTypPerspectiveXref_NGM Table
Description
System reference table that stores the financial perspective codes that correspond to each output table type.
Properties
Creation Date10/9/2020 10:57 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows32
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Unique system-generated sequential identifier for the output table record.

  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
int4   
 

Name of the output table.

  • LOSS_ByLocationByTreaty
  • LOSS_ByTreatyExposureAttribute
  • LOSS_ByLayerByTreaty
  • LOSS_ByContractByTreaty
  • LOSS_ByTreatyExposureAttributeGeo
varchar512   
Primary Key 

Two-digit code that represents the Financial Perspective associated with the output table. The output table corresponds to one of the financial perspective codes.

  • GR
  • GU
  • NT
  • RE
varchar10   
Objects that tOutputTypPerspectiveXref_NGM depends on
 Database ObjectObject TypeDescriptionDep Level
tOutputTable tabletOutputTableTable

Stores the database tables where the output is stored.

1
See Also

Related Objects

AIRReference Database