LM_PGESGN_VW

(SQL View)
Index Back

ESignature Record

ESignature Record

SELECT LM_ESIGN_ID , LM_PRG_REG_ID , LM_PRG_ID , LM_ENRLMT_ID , LM_LC_ID , LM_PERSON_ID , LM_SELF_ACKNOWLEDG , %subrec(LM_ROWAUDIT_SBR, A) FROM PS_LM_PRGESIGN_HST A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_ESIGN_ID Number(10,0) DECIMAL(10) NOT NULL E Signature ID
2 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.
3 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
4 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
5 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
6 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
7 LM_SELF_ACKNOWLEDG Character(1) VARCHAR2(1) NOT NULL Self Acknowledge
8 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
9 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
10 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
11 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid