PNLGRPNAMEMARKETSEQNOSEQNUMWL_TEMPL_URLKEY(SQL Table) |
Index Back |
|---|---|
URL key recordHolds the key fields for accessing a specific component. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | WL_TOKENID | Character(10) | VARCHAR2(10) NOT NULL | Value |
| 7 | WL_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 8 | WL_ADDED_DTTM | DateTime(26) | TIMESTAMP | Date/Time Created |
| 9 | WL_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By |
| 10 | WL_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | Date Modified |