SSR_VB_ROLL_BND

(SQL View)
 Index Back

Bind Record for VB POP Select


SELECT hdr.EMPLID ,hdr.INSTITUTION ,hdr.STRM , FF.SCC_CAF_ATTR_SEQ , FF.SCC_CAF_ATTRIB_NM , FF.SCC_CAF_ATTR_VAL , FF.SCC_CAF_ATTR_NVAL , FF.SCC_CAF_ATTR_DVAL , FF.SCC_CAF_ATTR_TVAL , FF.SCC_CAF_ATTR_TIME , FF.SCC_CAF_ATTR_YNO , FF.SCC_CAF_ATTR_LVAL ,SUM1.SSR_VB_YEL_RIBBON FROM PS_SSR_VB_FED_FLD ff , ps_ssr_vb_sum_hdr hdr , PS_SSR_VB_SUMMARY sum1 WHERE hdr.emplid = ff.emplid AND hdr.institution = ff.institution AND hdr.strm = ff.strm AND sum1.EMPLID = hdr.EMPLID UNION ALL SELECT SF.EMPLID ,SF.INSTITUTION ,SF.STRM ,SF.SCC_CAF_ATTR_SEQ , SF.SCC_CAF_ATTRIB_NM , SF.SCC_CAF_ATTR_VAL , SF.SCC_CAF_ATTR_NVAL , SF.SCC_CAF_ATTR_DVAL , SF.SCC_CAF_ATTR_TVAL , SF.SCC_CAF_ATTR_TIME , SF.SCC_CAF_ATTR_YNO , SF.SCC_CAF_ATTR_LVAL , sum1.SSR_VB_YEL_RIBBON FROM PS_SSR_VB_STA_FLD SF , ps_ssr_vb_sum_hdr hdr , PS_SSR_VB_SUMMARY sum1 WHERE hdr.emplid = SF.emplid AND hdr.institution = SF.institution AND hdr.strm = SF.strm AND sum1.EMPLID = hdr.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

3 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: SSR_VB_TERM_VW

4 SCC_CAF_ATTR_SEQ Number(4,0) SMALLINT NOT NULL Attribute Sequence
5 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute

Prompt Table: %EDITTABLE18

6 SCC_CAF_ATTR_VAL Character(20) VARCHAR2(20) NOT NULL Attribute Value
7 SCC_CAF_ATTR_NVAL Number(32,11) DECIMAL(31,11) NOT NULL Numeric Value
8 SCC_CAF_ATTR_DVAL Date(10) DATE Date Value
9 SCC_CAF_ATTR_TVAL Character(50) VARCHAR2(50) NOT NULL Text Value
10 SCC_CAF_ATTR_TIME Time(15) TIMESTAMP Time Value
11 SCC_CAF_ATTR_YNO Character(1) VARCHAR2(1) NOT NULL Yes/No Value

Y/N Table Edit

12 SCC_CAF_ATTR_LVAL Long Character CLOB Long Text Value
13 SSR_VB_YEL_RIBBON Character(1) VARCHAR2(1) NOT NULL Yellow Ribbon

Y/N Table Edit