KGSLOPA

Tables (7)

LPCMMethods (Untitled3)

    LPCMs (Untitled2)

    • ID (Key) — INT — Primary key — NOT NULL
    • Classification (Field) — NVARCHAR(100)
    • Description (Field2) — NVARCHAR(500)
    • SubClassification (Field3) — NVARCHAR(100)
    • SbuDescription (Field4) — NVARCHAR(500)
    • Calculation (Field5) — NVARCHAR(500)
    • CalculationMethodID (Field6) — INT
    • IsUse (Field7) — BIT

    LPECMethods (Untitled)

    • ID (Key) — INT — Primary key — NOT NULL
    • No (Field) — INT
    • SeasonalRiskTitle (Field2) — NVARCHAR(500)
    • SeasonalRiskContent (Field3) — NVARCHAR(1000)
    • SeasonalRiskSource (Field4) — NVARCHAR(500)
    • ProcessStateRiskTitle (Field5) — NVARCHAR(500)
    • ProcessStateRiskContent (Field6) — NVARCHAR(1000)
    • ProcessStateRiskSource (Field7) — NVARCHAR(500)
    • SpecificCampainRiskTitle (Field8) — NVARCHAR(500)
    • SpecificCampainRiskContent (Field9) — NVARCHAR(1000)
    • SpecificCampainRiskSource (Field10) — NVARCHAR(500)
    • OperationPeriodRiskTitle (Field11) — NVARCHAR(500)
    • OperationPeriodRiskContent (Field12) — NVARCHAR(1000)
    • OperationPeriodRiskSource (Field13) — NVARCHAR(500)
    • OthersTitle (Field14) — NVARCHAR(500)
    • OthersContent (Field15) — NVARCHAR(1000)
    • OthersSource (Field16) — NVARCHAR(500)
    • IsUse (Field17) — BIT

    LPECs (LOPA EC)

    • ID (Key) — INT — Primary key — NOT NULL
    • Classification (Field) — NVARCHAR(100)
    • Description (Field2) — NVARCHAR(500)
    • SubClassification (Field3) — NVARCHAR(100)
    • SubDescription (Field4) — NVARCHAR(500)
    • Calculation (Field5) — NVARCHAR(500)
    • CalculationMethodID (Field6) — INT
    • IsUse (Field7) — BIT

    LPIEs (LOPA IE)

    • ID — INT — Primary key — NOT NULL
    • No (Field2) — INT
    • Description — NVARCHAR(500)
    • GenericIEF — FLOAT
    • Consideration (SpecialConsideration) — NVARCHAR(500)
    • Assurance — NVARCHAR(100)
    • ValidationMethod (GenericValidation) — NVARCHAR(500)
    • Guidance — NVARCHAR(500)
    • IsUse (Field) — BIT

    LPIPLs (LOPA IPL)

    • ID (Key) — INT — Primary key — NOT NULL
    • No (Field) — INT
    • Description (Field2) — NVARCHAR(500)
    • Preventive (Field3) — NVARCHAR(500)
    • GenericPFD (Field4) — FLOAT
    • RiskCategory (Field5) — NVARCHAR(100)
    • Consideration (Field6) — NVARCHAR(500)
    • ValidationMethod (Field7) — NVARCHAR(500)
    • IsUse (Field8) — BIT

    LPSGs (LOPA SG)

    • ID (Key) — INT — Primary key — NOT NULL
    • NO (Field3)
    • SGType (Field) — NVARCHAR(100)
    • Description (Field2) — NVARCHAR(500)
    • IsUse (Field4) — BIT