Reporting View Target: PERSONNEL_ACTION

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PERSONNEL_ACTION_COMMENT

Description Contains text lines associated with the personnel action transaction number.
Key & Frequency One row per person per PAF transaction number per PAF comment sequence number
Recommended Search Columns PERSON_UID, PAF_TRANSACTION_NUMBER, PAF_COMMENT_SEQUENCE_NUMBER

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PAF_COMMENT Paf Comment Comments recorded by the user related to this personnel action transaction and sequence number. VARCHAR2(4000)
NORCMNT

NORCMNT_COMMENTS

PAF_COMMENT_ACTIVITY_DATE Paf Comment Activity Date Date of last activity for the record. DATE
NORCMNT

NORCMNT_ACTIVITY_DATE

PAF_COMMENT_DATA_ORIGIN Paf Comment Data Origin Source system that created or updated the row. VARCHAR2(63)
NORCMNT

NORCMNT_DATA_ORIGIN

PAF_COMMENT_SEQUENCE_NUMBER Paf Comment Sequence Number Display sequence for each of field changed in the approval transaction. NUMBER
NORCMNT

NORCMNT_SEQ_NO

PAF_COMMENT_USER_ID Paf Comment User ID Oracle ID of the user who created or changed the record. VARCHAR2(63)
NORCMNT

NORCMNT_USER_ID

PAF_TRANSACTION_NUMBER Paf Transaction Number System-generated number that is created when you enter information pertaining to an Electronic Personnel Action. NUMBER
NORCMNT

NORCMNT_TRANSACTION_NO

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER
NOBTRAN

NOBTRAN_PIDM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

Ver: 9.0

Description	Contains text lines associated with the personnel action transaction number.
Key & Frequency	One row per person per PAF transaction number per PAF comment sequence number
Recommended Search Columns	PERSON_UID, PAF_TRANSACTION_NUMBER, PAF_COMMENT_SEQUENCE_NUMBER

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PAF_COMMENT	Paf Comment	Comments recorded by the user related to this personnel action transaction and sequence number.	VARCHAR2(4000)	NORCMNT	NORCMNT_COMMENTS
PAF_COMMENT_ACTIVITY_DATE	Paf Comment Activity Date	Date of last activity for the record.	DATE	NORCMNT	NORCMNT_ACTIVITY_DATE
PAF_COMMENT_DATA_ORIGIN	Paf Comment Data Origin	Source system that created or updated the row.	VARCHAR2(63)	NORCMNT	NORCMNT_DATA_ORIGIN
PAF_COMMENT_SEQUENCE_NUMBER	Paf Comment Sequence Number	Display sequence for each of field changed in the approval transaction.	NUMBER	NORCMNT	NORCMNT_SEQ_NO
PAF_COMMENT_USER_ID	Paf Comment User ID	Oracle ID of the user who created or changed the record.	VARCHAR2(63)	NORCMNT	NORCMNT_USER_ID
PAF_TRANSACTION_NUMBER	Paf Transaction Number	System-generated number that is created when you enter information pertaining to an Electronic Personnel Action.	NUMBER	NORCMNT	NORCMNT_TRANSACTION_NO
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	NOBTRAN	NOBTRAN_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA