HCSC_SS_SEC_TAO

(SQL Table)
Index Back

SS Framework Security rec

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
6 HCSC_SS_GROUP_ID Character(10) VARCHAR2(10) NOT NULL Group ID
7 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
8 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number
9 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
11 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.

Y/N Table Edit

12 HCSC_SS_DIGITAL_SG Character(1) VARCHAR2(1) NOT NULL Digital Signature
13 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

Prompt Table: PSPACKAGROOT_VW

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

Prompt Table: PSPACKAGPATH_VW

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

Prompt Table: PSPACKAGCLAS_VW

16 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
17 DS_ID Character(30) VARCHAR2(30) NOT NULL Data Source ID
18 DATA_EXISTS Character(1) VARCHAR2(1) NOT NULL Data Exists

Y/N Table Edit

19 GROUPNAME Character(50) VARCHAR2(50) NOT NULL Directory Group Name
20 HCSC_SS_RPTTITLE Character(60) VARCHAR2(60) NOT NULL Report Title for Self-Service Page.
21 HCSC_SS_RPTNAME Character(30) VARCHAR2(30) NOT NULL SS Report Name