SSR_AIR_ATTR_VW

(SQL View)
 Index Back

Academic Item Attributes


SELECT a.INSTITUTION , a.SSR_ITEM_ID , a.EFFDT , b.SCC_CAF_ATTR_SEQ , b.SCC_CAF_ATTRIB_NM , b.SCC_CAF_ATTR_VAL , b.SCC_CAF_ATTR_NVAL , b.SCC_CAF_ATTR_DVAL , b.SCC_CAF_ATTR_TVAL , b.SCC_CAF_ATTR_TIME , b.SCC_CAF_ATTR_YNO , b.SCC_CAF_ATTR_LVAL , b.SSR_SHOW_STU_SS , a.END_EFFDT , a.EFF_STATUS FROM PS_SSR_AIR_HDR a , PS_SSR_AIR_ADD b WHERE a.INSTITUTION=b.INSTITUTION AND a.SSR_ITEM_ID=b.SSR_ITEM_ID AND a.EFFDT=b.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID

Default Value: 00000000000

3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

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_SHOW_STU_SS Character(1) VARCHAR2(1) NOT NULL Show in Student SS

Y/N Table Edit

Default Value: N

14 END_EFFDT Date(10) DATE End Effdt
15 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive