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)