SCC_AFL_PRS_MSG (SQL Table)	Index Back
Affiliation Person Messages This records contains any error messages reported when an affiliation was processed. In certain cases illegal dates may be passed to the affilaition engine in which case an entry will be logged in this table.

SCC_AFL_PRS_MSG

(SQL Table)

Affiliation Person Messages

This records contains any error messages reported when an affiliation was processed. In certain cases illegal dates may be passed to the affilaition engine in which case an entry will be logged in this table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution
Prompt Table: INSTITUTION_TBL

3 SCC_AFL_CODE Character(10) VARCHAR2(10) NOT NULL Affiliations Code
Prompt Table: SCC_AFL_LVS_VW

4 MESSAGE_SEQ Number(9,0) DECIMAL(9) NOT NULL Message Sequence

5 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

7 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Institution Prompt Table: INSTITUTION_TBL
3	SCC_AFL_CODE	Character(10)	VARCHAR2(10) NOT NULL	Affiliations Code Prompt Table: SCC_AFL_LVS_VW
4	MESSAGE_SEQ	Number(9,0)	DECIMAL(9) NOT NULL	Message Sequence
5	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
6	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
7	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
8	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.