PTIASPPKGGUIDPTIACUSTNAMEDefault Value: 1
Default Value: 1
Default Value: 1
Default Value: 1
N=No
Y=Yes
Default Value: N
A=Active
IA=Inactive
PTIASPPKGCUSTVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.PTIASPPKGGUID ,A.PTIACUSTNAME ,A.PTIACUSTDESC ,A.PTIACUSTCRIT1 ,A.PTIACUSTCRIT2 ,A.PTIACUSTCRIT3 ,A.PTIACUSTCRIT4 ,A.PTIACUSTPKGINCLUDE ,B.PTIACUSTACTIVE ,B.PTIACUSTOWNER FROM PS_PTIASPPKGCUST A, PS_PTIACUSTREPO B WHERE A.PTIACUSTNAME = B.PTIACUSTNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIASPPKGGUID |
Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| 2 | PTIACUSTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Customization Name |
| 3 | PTIACUSTDESC | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 4 | PTIACUSTCRIT1 | Number(10,0) | DECIMAL(10) NOT NULL |
Calc Criteria 1
Default Value: 1 |
| 5 | PTIACUSTCRIT2 | Number(10,0) | DECIMAL(10) NOT NULL |
Calc Criteria 2
Default Value: 1 |
| 6 | PTIACUSTCRIT3 | Number(10,0) | DECIMAL(10) NOT NULL |
Calc Criteria 3
Default Value: 1 |
| 7 | PTIACUSTCRIT4 | Number(10,0) | DECIMAL(10) NOT NULL |
Calc Criteria 4
Default Value: 1 |
| 8 | PTIACUSTPKGINCLUDE | Character(1) | VARCHAR2(1) NOT NULL |
Include in Package
N=No Y=Yes Default Value: N |
| 9 | PTIACUSTACTIVE | Character(2) | VARCHAR2(2) NOT NULL |
Customization Active
A=Active IA=Inactive |
| 10 | PTIACUSTOWNER | Character(100) | VARCHAR2(100) NOT NULL | Owner |