SCC_INTFCHRASGN(SQL Table) |
Index Back |
|---|---|
Interface Report HR DataInterface Report HR Data Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Signed Number(6,0) | DECIMAL(5) NOT NULL | Parent Type | |
| 2 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 1 | |
| 3 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 2 | |
| 4 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 3 | |
| 5 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 4 | |
| 6 | SCC_ASSIGNED_TO | Character(30) | VARCHAR2(30) NOT NULL | Assigned To |
| 7 | SCC_RESOLUTIONSTAT | Character(4) | VARCHAR2(4) NOT NULL |
Resolution Status
DISC=Disconnect From HR IGNR=Ignore and Document LATR=Resolve Later and Document OWN=Take Ownership SYNC=Synchronize with HR UNST=UnStarted Default Value: UNST |
| 8 | SCC_COMMENTS | Long Character | CLOB | Comments |