GP_AUD_SYS_DTL

(SQL Table)
Index Back

System PIN Details

System PIN Details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 SYSPIN_SRC Character(1) VARCHAR2(1) NOT NULL System Element Source
D=Database Field
S=System-Computed
3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: GP_PSRECDEFN_VW

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
5 GP_AUD_CHAR_VAL1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
6 SYSPIN_SETID_IND Character(1) VARCHAR2(1) NOT NULL SetID Controlled

Y/N Table Edit

7 PROMPTVIEW Character(18) VARCHAR2(18) NOT NULL Element Entry Prompt View

Prompt Table: GP_PSRECDEFN_VW

8 PIN_SETID_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_SY5_VW

9 CHART_FLD_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether an element can be used as chart field (Y/N)

Y/N Table Edit

10 EVAL_GRP_ID Character(5) VARCHAR2(5) NOT NULL Evaluate Group ID
11 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.
12 GROUPBOX_SYS Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.
13 GROUPBOX_SYS2 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.
14 GROUPBOX_SYS3 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.