PTIAAUCHANNELNAMEF=Fixed
S=Subscribed
U=Unsubscribed
PTIAAUCHANNEL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIAAUCHANNELNAME |
Character(50) | VARCHAR2(50) NOT NULL | Channel Name |
| 2 | PTIAAUCHANNELDESC | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 3 | PTIASPLICGRP | Character(18) | VARCHAR2(18) NOT NULL | This is the database License Group for example FIN/SCM or HRMS |
| 4 | PTIASPAPPVERSION | Character(15) | VARCHAR2(15) NOT NULL | Application Version including point release eg 9.2 |
| 5 | PTIAAUPLATFORM | Character(32) | VARCHAR2(32) NOT NULL | Operating System |
| 6 | PTIAAUCHNLSUBSSTAT | Character(1) | VARCHAR2(1) NOT NULL |
Subscribe State
F=Fixed S=Subscribed U=Unsubscribed |
| 7 | PTIAAUUPDCOUNT | Number(10,0) | DECIMAL(10) NOT NULL | New Updates |