cdptables
Tables (45)
TBLREFCO (Untitled14)
- Key — Primary key — NOT NULL
tblDEVCDPActivity (CopyOfUntitled122)
- CDPActivityId (Key) — int — Primary key — NOT NULL
- CDPCd (Key3) — char(20) — Foreign key → tblREFCompDevProg.CDPCd — NOT NULL
- CDPActvCd (Key2) — char(5) — Foreign key → tblDEVCDPActv.CDPActvCd — NOT NULL
- RoomDetCd (Key4) — char(7) — Foreign key → tblREFRoomDet.RoomDetCd — NOT NULL
tblDEVCDPActv (CopyOfCopyOfUntitled122)
- CDPActvCd (Key) — char(5) — Primary key — NOT NULL
- CDPActvNm (Field) — varchar(80)
- CDPActvMtd (Field2) — char(15)
- CDPActvStDt (Field3) — datetime
- CDPActvEndDt (Field4) — datetime
- CDPActvStTime (Field5) — datetime
- CDPActvEndTime (Field6) — datetime
- RqstActvId (Key2) — int — Foreign key → tblDEVRqstActv.RqstActvId — NOT NULL
- BUOrgChart (Field7) — varchar(50)
tblDEVCDPComp (CopyOfUntitled4)
- CDPCompId (Key) — int — Primary key — NOT NULL
tblDEVCDPEval (Untitled9)
- CDPEvalId (Key) — int — Primary key — NOT NULL
- COID (Key5) — int — Foreign key → tblRSCO.COID — NOT NULL
- CDPSchdId (Key3) — int — Foreign key → tblDEVCDPSchd.CDPSchdId — NOT NULL
- CDPCd (Key2) — char(20) — Foreign key → tblREFCompDevProg.CDPCd — NOT NULL
- QuestionsCd (Key4) — char(4) — Foreign key → tblREFQuestion.QuestionsCd — NOT NULL
- CDPEvalComt (Field2) — varchar(300)
- CDPEvalDt (Field3) — datetime
tblDEVCDPEvalRtq (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- CDPEvalRtgId (Key) — int — Primary key — NOT NULL
- CDPEvalId (Key3) — int — Foreign key → tblDEVCDPEval.CDPEvalId — NOT NULL
- CDPEvalRtg (Field) — int
- SubqstnCd (Key2) — char(6) — Foreign key → tblREFSubquestion.SubqstnCd — NOT NULL
tblDEVCDPOfferLtr (CopyOfUntitled3)
- CDPOfferLtrId (Key) — int — Primary key — NOT NULL
- CDPSchdId (Key2) — int — Foreign key → tblDEVCDPSchd.CDPSchdId — NOT NULL
- CDPOfferLtrRefNo (Field) — varchar(50)
- CDPOfferLtrSubj (Field2) — varchar(300)
- CDPLtrContent1 (Field3) — text
- CDPLtrContent2 (Field4) — text
- CDPLtrContent3 (Field5) — text
- CDPLtrContent4 (Field6) — text
- CDPOfferLtrMotto (Field7) — varchar(300)
- CDPOfferLtrIssueDt (Field8) — datetime
- CDPOfferLtrIssueByCOID (Field9) — int
- CDPOfferLtrIssueByBUID (Field10) — int
- CDPOfferLtrIssuer (Field11) — text
tblDEVCDPRegCloseDt (Untitled10)
- CDPRegCloseDtId (Key) — int — Primary key — NOT NULL
- CDPSchdId (Key2) — int — Foreign key → tblDEVCDPSchd.CDPSchdId — NOT NULL
- CDPRegCloseDt (Field) — datetime
- CDPRegCloseDtStatus (Field2) — bit
tblDEVCDPResult (CopyOfCopyOfUntitled3)
- CDPResultId (Key) — int — Primary key — NOT NULL
- CDPResult (Field) — varchar(20)
- CDPResultReason (Field2) — varchar(300)
- CDPResultActnPlan (Field3) — varchar(80)
- COID (Field5) — int
- CDPCd (Key2) — char(20) — Foreign key → tblREFCompDevProg.CDPCd — NOT NULL
- CDPSchdId (Key3) — int — Foreign key → tblDEVCDPSchd.CDPSchdId — NOT NULL
- AprvlStatusCd (Key4) — int — Foreign key → tblREFAprvlStatus.AprvlStatusCd — NOT NULL
- CDPResultDt (Field4) — datetime
tblDEVCDPRqstComp (CopyOfCopyOfUntitled4)
- CDPCompId (Key) — int — Primary key — NOT NULL
- RCRId (Key2) — int — Foreign key → tblDEVRecmCDPRqst.RCRId — NOT NULL
tblDEVCDPRqstStatus (CopyOfCopyOfCopyOfUntitled2)
- CDPRqstStatusId (Key) — int — Primary key — NOT NULL
- CURId (Key2) — int — Foreign key → tblDEVCOUponRqst.CURId — NOT NULL
- AprvlStatusCd (Key3) — int — Foreign key → tblREFAprvlStatus.AprvlStatusCd — NOT NULL
- CDPRqstStatusStDt (Field) — datetime
- CDPRqstStatusEndDt (Field2) — datetime
tblDEVCDPSchd (Untitled3)
- CDPSchdId (Key) — int — Primary key — NOT NULL
tblDEVCDPSecreteriat (Untitled11)
- CDPSecId (Key) — int — Primary key — NOT NULL
- COID (Field) — int
- CDPCd (Key2) — char(20) — Foreign key → tblREFCompDevProg.CDPCd — NOT NULL
tblDEVCOUponRqst (CopyOfCopyOfCopyOfCopyOfUntitled2)
- CURId (Key) — int — Primary key — NOT NULL
- COID (Key2) — int — Foreign key → tblRSCO.COID — NOT NULL
- RCRId (Key3) — int — Foreign key → tblDEVRecmCDPRqst.RCRId — NOT NULL
- CDPCd (Key4) — char(20) — Foreign key → tblREFCompDevProg.CDPCd — NOT NULL
- HRActCd (Key5) — char(2) — Foreign key → tblREFHRActv.HRActCd — NOT NULL
- CDPSchdId (Key6) — int — Foreign key → tblDEVCDPSchd.CDPSchdId — NOT NULL
tblDEVCourseVenue (Untitled12)
- CourseVenueId (Key) — int — Primary key — NOT NULL
- CourseCd (Key2) — char(6) — Foreign key → tblREFCourse.CourseCd — NOT NULL
tblDEVHistCourse (Untitled)
- CDPResultId (Key) — int — Primary key — NOT NULL
- CDPCatCd (Key2) — char(4) — Foreign key → tblREFCDPCat.CDPCatCd — NOT NULL
- CDPSpcltnCd (Key3) — char(6) — Foreign key → tblREDCDPSpcltn.CDPSpcltnCd — NOT NULL
- COID (Key4) — int — Foreign key → tblRSCO.COID — NOT NULL
tblDEVRecmCDPRqst (CopyOfCopyOfCopyOfCopyOfUntitled22)
- RCRId (Key) — int — Primary key — NOT NULL
tblDEVRqstActv (CopyOfCopyOfCopyOfUntitled122)
- RqstActvId (Key) — int — Primary key — NOT NULL
- RqstActvNm (Field) — varchar(80
- RqstActvDesc (Field2) — varchar(300)
- RqstActvMtd (Field3) — char(15)
- RqstActvStDt (Field4) — datetime
- RqstActvEndDt (Field5) — datetime
- RqstActvStTime (Field6) — datetime
- RqstActvEndTime (Field7) — datetime
- RqstActvStatus (Field8) — varchar(20)
- RCRId (Key3) — int — Foreign key → tblDEVRecmCDPRqst.RCRId — NOT NULL
- AprvlStatusCd (Key2) — int — Foreign key → tblREFAprvlStatus.AprvlStatusCd — NOT NULL
tblEDActlPos (Untitled5)
- APId (Key) — int — Primary key — NOT NULL
tblEDBusUnit (Untitled6)
- BUId (Key) — int — Primary key — NOT NULL
tblREDCDPSpcltn (CopyOfCopyOfUntitled)
- CDPSpcltnCd (Key) — char(6) — Primary key — NOT NULL
- CDPCatCd (Key2) — char(4) — Foreign key → tblREFCDPCat.CDPCatCd — NOT NULL
- CDPSpcltnNm (Field) — varchar(80)
- BUId (Field2) — int
tblREFAprvlStatus (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- AprvlStatusCd (Key) — int — Primary key — NOT NULL
tblREFCDPCat (CopyOfUntitled)
- CDPCatCd (Key) — char(4) — Primary key — NOT NULL
- CDPCatNm (Field) — varchar(80)
- BUId (Field2) — int
tblREFCDPType (CopyOfCopyOfUntitled2)
- CDPTypeCd (Key) — char(4) — Primary key — NOT NULL
- CDPTypeNm (Field) — varchar(50)
tblREFCDPVenue (CopyOfCopyOfUntitled132)
- CDPVenueCd (Key) — char(5) — Primary key — NOT NULL
- CDPVenueNm (Field) — varchar(100)
- CDPVenueAddr1 (Field2) — varchar(100)
- CDPVenueAddr2 (Field3) — varchar(100)
- CDPVenueAddr3 (Field4) — varchar(100)
- CDPVenuePostcode (Field5) — varchar(12)
- CityCd (Key2) — char(6) — Foreign key → tblREFCity.CityCd — NOT NULL
- StateCd (Key3) — char(2) — Foreign key → tblREFState.StateCd — NOT NULL
- CountryCd (Key4) — char(3) — Foreign key → tblREFCountry.CountryCd — NOT NULL
- BUOrgChart (Field6) — varchar(50)
tblREFCity (CopyOfCopyOfCopyOfUntitled123)
- CityCd (Key) — char(6) — Primary key — NOT NULL
tblREFCompDef (CopyOfCopyOfUntitled42)
- CompDefLevel (Key) — int — Primary key — NOT NULL
- CompRefCd (Field5) — char(8) — dbhrmis tak jupe link tbl tblrefco
- CompDefDesc (Field) — varchar(2000)
- CompDefBehaviour (Field2) — varchar(2000)
- CompDefSampl (Field3) — varchar(3000)
- CompDefIntSubmitStatusInd (Field4) — bit
tblREFCompDevProg (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)
- CDPCd (Key) — char(20) — Primary key — NOT NULL
- CDPCatCd (Key4) — char(4) — Foreign key → tblREFCDPCat.CDPCatCd — NOT NULL
- CDPSpcltnCd (Key5) — char(6) — Foreign key → tblREDCDPSpcltn.CDPSpcltnCd — NOT NULL
- ModeOfDlvryCd (Key8) — char(2) — Foreign key → tblREFModeOfDelivery.ModeOfDlvryCd — NOT NULL
- SponsorCd (Key7) — char(10) — Foreign key → tblRefDEVSponsor.SponsorCd — NOT NULL
- CDPNm (Field) — varchar(500)
- CDPStatus (Field2) — bit
- CDPType (Field3) — varchar(20)
- CDPDesc (Field4) — varchar(300)
- CDPObj (Field5) — varchar(300)
- CDPLearningPoint (Field6) — varchar(300)
- CDPMaxPar (Field7) — int
- CDPMinPar (Field8) — int
- CDPInd (Field9) — char(3)
- CDPFeeCost (Field10) — money
- CDPAcmdtnCost (Field11) — money
- CDPMealCost (Field12) — money
- CDPToolCost (Field13) — money
- CDPTransCost (Field14) — money
- CDPOtherCost (Field15) — money
- CDPDevCost (Field16) — money
- CDPTrainerCost (Field17) — money
- CDPTotalCost (Field18) — money
- BUOrgChart (Field19) — varchar(50)
- RCRId (Key2) — int — Foreign key → tblDEVRecmCDPRqst.RCRId — NOT NULL
- AprvlStatusCd (Key3) — int — Foreign key → tblREFAprvlStatus.AprvlStatusCd — NOT NULL
- CDPRegDur (Field20) — int
- CourseID (Field21) — int
- CDPOwner (Field22) — varchar(10)
- TrngStrucId (Key9) — int — Foreign key → tblREFDEVTrngStruc.TrngStrucId — NOT NULL
- TRMResultInd (Field23) — bit
- CDPResultValidPeriod (Field24) — int
- CDPInduksiInd (Field25) — int
- CDPTypeCd (Key6) — char(4) — Foreign key → tblREFCDPType.CDPTypeCd — NOT NULL
- CDPCategoryCd (Field26) — char(4)
- MajorMinorCd (Field27) — char(6)
- CDPIndCd (Field28) — char(4)
tblREFCompDevProgObj (Untitled8)
- CDPObjId (Key) — int — Primary key — NOT NULL
- CDPCd (Key2) — char(20) — Foreign key → tblREFCompDevProg.CDPCd — NOT NULL
- CDPObjDesc (Field) — varchar(500)
tblREFCountry (CopyOfCopyOfCopyOfCopyOfUntitled123)
- CountryCd (Key) — char(3) — Primary key — NOT NULL
tblREFCourse (CopyOfUntitled12)
- CourseCd (Key) — char(6) — Primary key — NOT NULL
- CourseNm (Field) — varchar(80)
- CourseMth (Field2) — int
- CourseYr (Field3) — int
- CourseInd (Field4) — bit
- MajorMinorCd (Key2) — char(6) — Foreign key → tblREFMajorMinor.MajorMinorCd — NOT NULL
- CourseProInd (Field5) — bit
- InstCd (Key3) — int — Foreign key → tblREFInst.InstCd — NOT NULL
tblREFDEVTrngStruc (CopyOfUntitled7)
- TrngStrucId (Key) — int — Primary key — NOT NULL
- TrngStrucNm (Field) — varchar(100)
- TrngStrucLvl (Field2) — varchar(100)
- ServPeriodSt (Field3) — int
- ServPeriodEnd (Field4) — int
tblREFHRActv (Untitled2)
- HRActCd (Key) — char(2) — Primary key — NOT NULL
tblREFInst (CopyOfCopyOfUntitled12)
- InstCd (Key) — int — Primary key — NOT NULL
tblREFMajorMinor (CopyOfCopyOfCopyOfUntitled12)
- MajorMinorCd (Key) — char(6) — Primary key — NOT NULL
- MajorMinor (Field) — varchar(70)
- MajorMinorStDt (Field2) — datetime
- MajorMInorEndDt (Field3) — datetime
- MajorMinorCatCd (Key2) — char(3) — Foreign key → tblREFMajorMinorCat.MajorMinorCatCd — NOT NULL
tblREFMajorMinorCat (CopyOfCopyOfCopyOfCopyOfUntitled12)
- MajorMinorCatCd (Key) — char(3) — Primary key — NOT NULL
- MajorMinor (Field) — varchar(50)
tblREFModeOfDelivery (Untitled7)
- ModeOfDlvryCd (Key) — char(2) — Primary key — NOT NULL
- ModeOfDlvryNm (Field) — varchar(80)
tblREFQuestion (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- QuestionsCd (Key) — char(4) — Primary key — NOT NULL
- Questions (Field3) — varchar(300)
- QuestionsInd (Field) — bit
tblREFRoomCat (CopyOfCopyOfUntitled13)
- RoomCatCd (Key) — char(4) — Primary key — NOT NULL
- RoomCatNm (Field) — varchar(50)
tblREFRoomClass (CopyOfUntitled13)
- RoomClassCd (Key) — char(4) — Primary key — NOT NULL
- RoomClassNm (Field) — varchar(30)
- RoomCatCd (Key2) — char(4) — Foreign key → tblREFRoomCat.RoomCatCd — NOT NULL
tblREFRoomDet (Untitled13)
- RoomDetCd (Key) — char(7) — Primary key — NOT NULL
- RoomDetNm (Field) — varchar(80)
- RoomClassCd (Key2) — char(4) — Foreign key → tblREFRoomClass.RoomClassCd — NOT NULL
- RoomDetCap (Field3) — int
- CDPVenueCd (Key3) — char(5) — Foreign key → tblREFCDPVenue.CDPVenueCd — NOT NULL
tblREFState (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled123)
- StateCd (Key) — char(2) — Primary key — NOT NULL
tblREFSubquestion (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- SubqstnCd (Key) — char(6) — Primary key — NOT NULL
- Subqstn (Field3) — varchar(300)
- SubqstnInd (Field2) — bit — Sistem akan menyimpan nilai ‘1’ untuk ‘Program Pembangunan Kompetensi‘ (soalan tersebut berkaitan dengan Program Pemban…
- QuestionsCd (Key2) — char(4) — Foreign key → tblREFQuestion.QuestionsCd — NOT NULL
tblRSCO (CopyOfCopyOfCopyOfUntitled)
- COID (Key) — int — Primary key — NOT NULL
tblRefDEVSponsor (Untitled4)
- SponsorCd (Key) — char(10) — Primary key — NOT NULL
- SponsorNm (Field) — varchar(300)
- BUId (Key3) — int — Foreign key → tblEDBusUnit.BUId — NOT NULL
- CDPSponsorInd (Field2) — bit
- APId (Key2) — int — Foreign key → tblEDActlPos.APId — NOT NULL
- EmailAddr (Field3) — varchar(80)