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 |