PROJECTNAMEMSGNODENAMEPTADSNAMEPTINITIALDTTMFF=From File
FN=From Node
TF=To File
TN=To Node
A=Active
I=Inactive
PSADSMSGSTITEM(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROJECTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| 2 | MSGNODENAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 3 | PTADSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name (see PSADSDEFN). |
| 4 | PTINITIALDTTM |
DateTime(26) | TIMESTAMP | Intial Time |
| 5 | PTADSCONTENTID | Number(6,0) | INTEGER NOT NULL | ADS Content Identifier |
| 6 | PTADSCOPYMODE | Character(2) | VARCHAR2(2) NOT NULL |
ADS Copy Mode
FF=From File FN=From Node TF=To File TN=To Node |
| 7 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 8 | IBTRANSACTIONID | Character(36) | VARCHAR2(36) NOT NULL | Transaction ID |
| 9 | IBPUBTRANSACTID | Character(36) | VARCHAR2(36) NOT NULL | Orig Transaction ID |
| 10 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 11 | PTADSBINDID | Character(254) | VARCHAR2(254) NOT NULL | ADS Content Bind Id |
| 12 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 13 | PTADSSTSDESCR | Character(50) | VARCHAR2(50) NOT NULL | Msg Status |
| 14 | PTSTSCHGDTTM | DateTime(26) | TIMESTAMP | Last Changed Time |