LM_PRG_BRSE_VW

(SQL View)
Index Back

Program Browse View

Program Browse View

SELECT LM_PRG_ID , LM_PRG_LONG_NM , LM_PRG_DESCR , LM_PRG_TYPE FROM PS_LM_PRG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
2 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
3 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description
4 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
CE=Certification
CU=Curriculum