ADM_FCN_PPL_VW (SQL View)	Index Back
Administrative Fcn People View This view is used to prompt for ADMIN_FUNCTION in PEOPLE COMMUNICATION, CHECKLIST, COMMENTS, TRACKING_GRPS, CHKLST_SRCH, COMM_SRCH, CMNT_SRCH.

ADM_FCN_PPL_VW

(SQL View)

Administrative Fcn People View

This view is used to prompt for ADMIN_FUNCTION in PEOPLE COMMUNICATION, CHECKLIST, COMMENTS, TRACKING_GRPS, CHKLST_SRCH, COMM_SRCH, CMNT_SRCH.

SELECT A.ADMIN_FUNCTION, A.EFFDT, A.DESCR FROM PS_ADM_FUNCTN_TBL A WHERE A.ADMIN_FCN_PEOPLE = 'Y'

Related Language Record: ADM_FCN_PPL_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description