PSADSMSGSTAT(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).
Prompt Table:
PSADSMSGNODE_VW
|
3 | PTINITIALDTTM | DateTime(26) | TIMESTAMP | Intial Time |
4 | PTPRJACTION | Character(10) | VARCHAR2(10) NOT NULL | Project Action |
5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
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) |