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 | WHEREUSEDPARTYPE | Signed Number(6,0) | DECIMAL(5) NOT NULL | Parent Type |
2 | OBJECTVALUE1 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 1 |
3 | OBJECTVALUE2 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 2 |
4 | OBJECTVALUE3 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 3 |
5 | OBJECTVALUE4 | 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 |