URL_GROUP_IDURL_ID_AUTO1=Block1
2=Block2
3=Block3
4=Block4
5=Block5
6=Block6
Default Value: 1
N=No
Y=Yes
Y/N Table Edit
GM_SPN_URL(SQL Table) |
Index Back |
|---|---|
Sponsor URL Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | URL_GROUP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Url Group Id |
| 2 | URL_ID_AUTO |
Number(4,0) | SMALLINT NOT NULL | URL IDENTIFIER |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 5 | BLOCK_NUMBER | Character(3) | VARCHAR2(3) NOT NULL |
Block Number
1=Block1 2=Block2 3=Block3 4=Block4 5=Block5 6=Block6 Default Value: 1 |
| 6 | USE_ALIAS | Character(1) | VARCHAR2(1) NOT NULL |
Use Description
N=No Y=Yes Y/N Table Edit |
| 7 | URL_1 | Character(254) | VARCHAR2(254) NOT NULL | URL #1 |