PTCAC_AUTHORIZE

 index back

Centralised Auth Conf record

New record for Centralised Authorization Configuration

PeopleSoft Field Name Field Type Column Type Description
PTCAC_CONFIG_ID Character(200) VARCHAR2(200) NOT NULL Configuration Id
PTCAC_SEQNO Number(15,0) DECIMAL(15) NOT NULL New field for Sequence Number;
PTCAC_AUTHTYPE Character(4) VARCHAR2(4) NOT NULL New field for Authorization type;
CREF=Content Reference
POP=Pagelet
UAPC=Application Class
UPGE=Component
UQRY=PS Query
USCR=IScript

Default: CREF

MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: PSMENUNAME_VW

PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: PSMENUCOMP_VW

MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values

Default: GBL

PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
SVC_APP_PACKAGE Character(30) VARCHAR2(30) NOT NULL Package Name

Prompt Table: PTCAC_PKG_VW

SVC_APPCLASS_PATH Character(127) VARCHAR2(127) NOT NULL App Package Path

Prompt Table: PTCAC_PATH_VW

SVC_APPCLASS Character(30) VARCHAR2(30) NOT NULL Class Name

Prompt Table: PTCAC_CLASS_VW

QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

Prompt Table: PTSF_QRYS_VW

PTCAC_PGLT_ID Character(30) VARCHAR2(30) NOT NULL Pagelet ID

Prompt Table: PTPPB_PAGELET

PTCAC_ISCRIPT_REC Character(30) VARCHAR2(30) NOT NULL IScript Record
PTCAC_ISCRIPT_FLD Character(30) VARCHAR2(30) NOT NULL IScript Field
PTCAC_ISCRIPT_FUNC Character(30) VARCHAR2(30) NOT NULL IScript Function
PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

Prompt Table: PSPACKAGROOT_VW

QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

Prompt Table: PSPACKAGPATH_VW

APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

Prompt Table: PSPACKAGCLAS_VW

CREF_LABEL Character(30) VARCHAR2(30) NOT NULL Content Reference Label
DESCR Character(30) VARCHAR2(30) NOT NULL Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

Prompt Table: PORTAL_NAME_VW

MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

Prompt Table: PTCAC_NODE_VW

STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Default: A

VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20