PTIACUSTREPO(SQL Table) |
Index Back |
|---|---|
Customization RepositoryCustomization Repository table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTIACUSTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Customization Name |
| 2 | PTIACUSTDESC | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 3 | PTIACUSTCRIT1 | Number(10,0) | DECIMAL(10) NOT NULL |
Calc Criteria 1
Default Value: 1 |
| 4 | PTIACUSTCRIT2 | Number(10,0) | DECIMAL(10) NOT NULL |
Calc Criteria 2
Default Value: 1 |
| 5 | PTIACUSTCRIT3 | Number(10,0) | DECIMAL(10) NOT NULL |
Calc Criteria 3
Default Value: 1 |
| 6 | PTIACUSTCRIT4 | Number(10,0) | DECIMAL(10) NOT NULL |
Calc Criteria 4
Default Value: 1 |
| 7 | PTIACUSTPKGINCLUDE | Character(1) | VARCHAR2(1) NOT NULL |
Include in Package
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 8 | PTIACUST3WAYMERGE | Character(4) | VARCHAR2(4) NOT NULL |
3 Way Merge Enabled
Y/N Table Edit Default Value: Y |
| 9 | PTIACUSTACTIVE | Character(2) | VARCHAR2(2) NOT NULL |
Customization Active
A=Active IA=Inactive Default Value: A |
| 10 | PTIACUSTOWNER | Character(100) | VARCHAR2(100) NOT NULL | Owner |
| 11 | PTIACUSTDETAILS | Long Character | CLOB | Additional Details |
| 12 | PTIACUST_ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 13 | PTIACUSTOPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated Oprid |
| 14 | PTIACUSTTRKATTR1 | Character(4) | VARCHAR2(4) NOT NULL |
Tracking Attribute
CA=Change Assistant MC=Manage Customizations MO=Manage Objects |
| 15 | PTIACUSTNXTREVDATE | Date(10) | DATE | Next Review Date |