CRSE_LICENSE_VW

(SQL View)
 Index Back

Training Course Goal-Licenses

Use COURSE_LICENSE to specify professional licenses or certifications that a particular training course is training students for. This record belongs to the Training Administration application. You can create multiple COURSE_LICENSE records for a course, each with a unique license/certification code.

SELECT A.COURSE ,A.LICENSE_CERTIF_CD ,B.RENEWAL_REQUIRED ,B.RENEWAL_PERIOD ,B.RENEWAL_LENGTH FROM PS_COURSE_LICENSE A ,PS_ACCOMP_TBL B WHERE A.LICENSE_CERTIF_CD=B.ACCOMPLISHMENT

  • Parent record: COURSE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: COURSE_TBL

    2 LICENSE_CERTIF_CD Character(8) VARCHAR2(8) NOT NULL License/Certification Code

    Prompt Table: LIC_CERTIF_VW

    3 RENEWAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Renewal Required
    N=No
    Y=Yes
    4 RENEWAL_PERIOD Character(1) VARCHAR2(1) NOT NULL Renewal Period
    D=Days
    M=Months
    W=Weeks
    Y=Years
    5 RENEWAL_LENGTH Number(3,0) SMALLINT NOT NULL Renewal Length