SCC_INTFCHRASGN

(SQL Table)
Index Back

Interface Report HR Data

Interface 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