HCSC_SS_RPT_SEC

(SQL Table)
Index Back

SS Reports Security

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

Y/N Table Edit

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

Prompt Table: PSPACKAGROOT_VW

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

Prompt Table: PSPACKAGPATH_VW

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

Prompt Table: PSPACKAGCLAS_VW

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

Y/N Table Edit

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