GPCN_PAY_APP (SQL Table)	Index Back
Payroll Result Approval This is the table that will be used to store all the data which will be used to store approval state.

GPCN_PAY_APP

(SQL Table)

Payroll Result Approval

This is the table that will be used to store all the data which will be used to store approval state.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
Prompt Table: GPCN_REQ_IN_VW

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID

4 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

5 GPCN_REPORT_DETAIL Character(1) VARCHAR2(1) NOT NULL the detail report of the approval.

6 GPCN_REPORT_SUM Character(1) VARCHAR2(1) NOT NULL the summarized report of the approval.

7 GPCN_CREATE_DATE Date(10) DATE NOT NULL the create date of the approval request.
Default Value: %Date

8 GPCN_CREATE_BY Character(30) VARCHAR2(30) NOT NULL the creator of the approval request.

9 GPCN_REASSIGN_TO Character(30) VARCHAR2(30) NOT NULL the assignee of the approval.
Prompt Table: GPCN_ASSIGN_VW

10 GPCN_REASSIGN Character(1) VARCHAR2(1) NOT NULL the re-assignee button of the approval.

11 GPCN_REPORT_DIS Character(1) VARCHAR2(1) NOT NULL the discrepancy report of the approval.

12 GPCN_APP_STATUS Character(3) VARCHAR2(3) NOT NULL record's status :submitted and saved and denied and approved
APP=Approved
DEN=Denied
SAV=Saved
SUB=Submitted

13 GPCN_COMMENTS Long Character CLOB the comments of the approval request.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GPCN_REQ_IN_VW
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID
4	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
5	GPCN_REPORT_DETAIL	Character(1)	VARCHAR2(1) NOT NULL	the detail report of the approval.
6	GPCN_REPORT_SUM	Character(1)	VARCHAR2(1) NOT NULL	the summarized report of the approval.
7	GPCN_CREATE_DATE	Date(10)	DATE NOT NULL	the create date of the approval request. Default Value: %Date
8	GPCN_CREATE_BY	Character(30)	VARCHAR2(30) NOT NULL	the creator of the approval request.
9	GPCN_REASSIGN_TO	Character(30)	VARCHAR2(30) NOT NULL	the assignee of the approval. Prompt Table: GPCN_ASSIGN_VW
10	GPCN_REASSIGN	Character(1)	VARCHAR2(1) NOT NULL	the re-assignee button of the approval.
11	GPCN_REPORT_DIS	Character(1)	VARCHAR2(1) NOT NULL	the discrepancy report of the approval.
12	GPCN_APP_STATUS	Character(3)	VARCHAR2(3) NOT NULL	record's status :submitted and saved and denied and approved APP=Approved DEN=Denied SAV=Saved SUB=Submitted
13	GPCN_COMMENTS	Long Character	CLOB	the comments of the approval request.