PTADSNAMEPTADSRELNAMEPrompt Table:
PTADSDEFN_DVW
Set Control Field: PTADSNAME
01=0..1
0N=0..*
11=1..1
1N=1..*
NN=*..*
Default Value: 11
01=0..1
0N=0..*
11=1..1
1N=1..*
NN=*..*
Default Value: 11
PSADSRELATION(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTADSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name (see PSADSDEFN). |
| 2 | PTADSRELNAME |
Character(80) | VARCHAR2(80) NOT NULL | Relation Name |
| 3 | PTADSNAME_TO | Character(30) | VARCHAR2(30) NOT NULL |
To Data Set Name
Prompt Table:
PTADSDEFN_DVW
|
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 6 | PTCARDINALITY_F | Character(2) | VARCHAR2(2) NOT NULL |
From Cardinality
01=0..1 0N=0..* 11=1..1 1N=1..* NN=*..* Default Value: 11 |
| 7 | PTCARDINALITY_T | Character(2) | VARCHAR2(2) NOT NULL |
To Cardinality
01=0..1 0N=0..* 11=1..1 1N=1..* NN=*..* Default Value: 11 |