GP_NRP_ACMCM_AD

(SQL Table)
Index Back

Adj. to Accumulators Comments

GP User Adjustment to Accumulator Values Comments record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
7 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
10 EMPL_RCD_ACUM Number(3,0) SMALLINT NOT NULL Accumulator Empl record
11 ACM_FROM_DT Date(10) DATE From Date
12 ACM_THRU_DT Date(10) DATE Through Date
13 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number
14 USER_ADJ_AMT_TS DateTime(26) TIMESTAMP User Adjustment Timestamp
15 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
16 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
17 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
18 COMMENTS Long Character CLOB Comment