SSS_NAV_FUNC_VW

(SQL View)
Index Back

SELECT a.FIELDVALUE , a.EFFDT , a.EFF_STATUS , a.XLATLONGNAME FROM PSXLATITEM a WHERE FIELDNAME = 'SSS_NAV_FUNC_AREA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSS_NAV_FUNC_AREA Character(4) VARCHAR2(4) NOT NULL Functional Area
SCSS=Campus Community Self-Service
SFSS=Financials Self-Service
SRFC=Faculty Center
SRPE=Program Enrollment
SRSS=Records Student Self-Service
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description