PTIADBNAMEN=No
Y=Yes
Default Value: N
PTIAMD_DBDEFN(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIADBNAME |
Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 2 | PTIADBDESC | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 3 | PTIADBHOSTNAME | Character(254) | VARCHAR2(254) NOT NULL | Host Name |
| 4 | PTIAMDPORTNUM | Character(5) | VARCHAR2(5) NOT NULL | Port Number |
| 5 | PTIANODENM | Character(40) | VARCHAR2(40) NOT NULL | Node Name |
| 6 | PTIAMDISSECURED | Character(1) | VARCHAR2(1) NOT NULL |
Use Https
N=No Y=Yes Default Value: N |
| 7 | PTIADBOPRID | Character(30) | VARCHAR2(30) NOT NULL | OPRID |
| 8 | PTIADBOPRPSW | Character(254) | VARCHAR2(254) NOT NULL | Password |
| 9 | PTIAAUCNNTID | Character(30) | VARCHAR2(30) NOT NULL | Database Connect ID |
| 10 | PTIAAUCNNTPSW | Character(254) | VARCHAR2(254) NOT NULL | Connect Password |
| 11 | PTIATOOLSREL | Character(20) | VARCHAR2(20) NOT NULL | Tools Release Number |
| 12 | PTIAPTPATCHREL | Number(2,0) | SMALLINT NOT NULL | Tools Patch Level |
| 13 | PTIADB_UPD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |