SCD_TMPLREVW_VW

(SQL View)
Index Back

Template Review Search

Template Review Search View

SELECT SCD_TEMPLATE_ID , SCD_VERSION_NBR , 'PE' , ' ' FROM PS_SCD_TEMPLATE_HD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCD_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID
2 SCD_VERSION_NBR Number(5,0) INTEGER NOT NULL Version Number
3 SCD_TEMPLATESTATUS Character(2) VARCHAR2(2) NOT NULL Template Status
AV=Available
NA=Not Available
PE=Pending
4 SCD_TEMPLATE_NAME Character(30) VARCHAR2(30) NOT NULL Template Name