SSR_ITMTYP_RULE (SQL View)	Index Back
Valid Rules for Item Types

SSR_ITMTYP_RULE

(SQL View)

Valid Rules for Item Types

SELECT a.SSR_ITEM_TYPE , a.SSR_PE_RULE_TYPE , b.DESCR FROM PS_SSR_RULETYP_ITM a , PS_SSR_RULETYP_TBL b WHERE a.SSR_PE_RULE_TYPE = b.SSR_PE_RULE_TYPE UNION SELECT c.SSR_ITEM_TYPE , a.SSR_PE_RULE_TYPE , b.DESCR FROM PS_SSR_RULETYP_ITM a , PS_SSR_RULETYP_TBL b , PS_SSR_ITEM_TYPE c WHERE a.SSR_PE_RULE_TYPE = b.SSR_PE_RULE_TYPE AND a.SSR_ITEM_TYPE = 'ALL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SSR_ITEM_TYPE Character(20) VARCHAR2(20) NOT NULL Academic Item Type
Prompt Table: SSR_ITEM_TYPE

2 SSR_PE_RULE_TYPE Character(20) VARCHAR2(20) NOT NULL Rule Type
CALC=Grade Calculation
NAG=Enrollment Audit
PGRS=Progression
PREC=Pre-Condition
RETK=Retake

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSR_ITEM_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Academic Item Type Prompt Table: SSR_ITEM_TYPE
2	SSR_PE_RULE_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Rule Type CALC=Grade Calculation NAG=Enrollment Audit PGRS=Progression PREC=Pre-Condition RETK=Retake
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description