SSF_PAYCNFR_AET

(SQL Table)
Index Back

POI Job Build

POI Job Build Process work record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 PAY_END_DT Date(10) DATE Pay Period End Date
6 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID
7 SF_DATETIME DateTime(26) TIMESTAMP SF DateTime

Default Value: %DATETIME

8 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

Default Value: SSF_PAYCNFR

9 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
10 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit for HRMS
11 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
12 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group