KGSLOPA
Tables (7)
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