SSR_PE_ITEM_VW

(SQL View)
Index Back

Item detail view


SELECT INSTITUTION , SSR_ITEM_ID ,EFFDT FROM PS_SSR_AIR_HDR

# 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