HCSC_SS_RPT_SEC(SQL Table) |
Index Back |
---|---|
SS Reports Security |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
3 | Character(8) | VARCHAR2(8) NOT NULL | Report Identifier | |
4 | Character(3) | VARCHAR2(3) NOT NULL | Country | |
5 | 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 |