PTCAC_AUTHORIZE

index back

Centralised Auth Conf record

New record for Centralised Authorization Configuration

PeopleSoft Field NameField TypeColumn TypeDescription
PTCAC_CONFIG_IDCharacter(200)VARCHAR2(200) NOT NULLConfiguration Id
PTCAC_SEQNONumber(15,0)DECIMAL(15) NOT NULLNew field for Sequence Number;
PTCAC_AUTHTYPECharacter(4)VARCHAR2(4) NOT NULLNew field for Authorization type;
CREF=Content Reference
POP=Pagelet
UAPC=Application Class
UPGE=Component
UQRY=PS Query
USCR=IScript

Default: CREF

MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).

Prompt Table: PSMENUNAME_VW

PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name

Prompt Table: PSMENUCOMP_VW

MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values

Default: GBL

PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
SVC_APP_PACKAGECharacter(30)VARCHAR2(30) NOT NULLPackage Name

Prompt Table: PTCAC_PKG_VW

SVC_APPCLASS_PATHCharacter(127)VARCHAR2(127) NOT NULLApp Package Path

Prompt Table: PTCAC_PATH_VW

SVC_APPCLASSCharacter(30)VARCHAR2(30) NOT NULLClass Name

Prompt Table: PTCAC_CLASS_VW

QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name

Prompt Table: PTSF_QRYS_VW

PTCAC_PGLT_IDCharacter(30)VARCHAR2(30) NOT NULLPagelet ID

Prompt Table: PTPPB_PAGELET

PTCAC_ISCRIPT_RECCharacter(30)VARCHAR2(30) NOT NULLIScript Record
PTCAC_ISCRIPT_FLDCharacter(30)VARCHAR2(30) NOT NULLIScript Field
PTCAC_ISCRIPT_FUNCCharacter(30)VARCHAR2(30) NOT NULLIScript Function
PACKAGEROOTCharacter(30)VARCHAR2(30) NOT NULLRoot Package ID

Prompt Table: PSPACKAGROOT_VW

QUALIFYPATHCharacter(127)VARCHAR2(127) NOT NULLQualified Package/Class Path

Prompt Table: PSPACKAGPATH_VW

APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID

Prompt Table: PSPACKAGCLAS_VW

CREF_LABELCharacter(30)VARCHAR2(30) NOT NULLContent Reference Label
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).

Prompt Table: PORTAL_NAME_VW

MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

Prompt Table: PTCAC_NODE_VW

STATUSCharacter(1)VARCHAR2(1) NOT NULLStatus Indicator
A=Active
I=Inactive

Default: A

VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19